Documentation New Perspectives Excel 2019 | Module 3: SAM Project 1a Scrub Jay

Documentation

New Perspectives Excel 2019 | Module 3: SAM Project 1a
Scrub Jay Peripherals
PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS
Author:AYANNA BONNER
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Sales Projections

Scrub Jay Peripherals
Sales Projections
Yearly Sales Projections (units)
Year-over-year growth estimate
5%10%
202110000100001000010000100001000010000
2022

Cost Estimates

Scrub Jay Peripherals
Cost Estimates
Manufacturing Cost Per UnitShipping Cost Per Unit
$ 28.02Vendor 1$ 6.18Shipper 1
$ 26.80Vendor 2$ 6.22Shipper 2
$ 31.15Vendor 3$ 5.83Shipper 3
AverageAverage
MaximumMaximum
MinimumMinimum
Manufacturing candidateShipping candidate

Profit Projections

Scrub Jay Peripherals
Profit Projections
Sales ProjectionsTimeline
Manufacturing cost$ 26.80Current date
Sales price$ 75.00Launch11/26/21
Shipping cost$ 5.83Factory work days to market
2021 sales units10,000
Gross Profit From Sales Projections
Year-over-year growth estimate
5%10%
2021
2022
Table to be completed

image1.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

  Purpose  Scaling a venture and ensuring its sustainability requires strategic thinking, financial planning, and collaboration. In this discussion,

  Purpose  Scaling a venture and ensuring its sustainability requires strategic thinking, financial planning, and collaboration. In this discussion, you will revisit the collaborative brainstorming process introduced in Unit 3 as part of the design thinking methodology. By returning to a collaborative space, you will refine your scaling, sustainability, and

Leadership Research ProjectAttached Files: ·  Leadership Research Project.docx

Leadership Research Project Attached Files: ·  Leadership Research Project.docx  (38.249 KB) Examine a famous leader applying concepts and theories explored in this course. Follow this outline: PART 1: INTRODUCTION 1)           Open your essay with an introduction section describing the selected leader.  2)           Summarize the leadership theory that you will be