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

Name: _______________________________ _______________________________ Date: _______________MGMT 414: Final Project EvaluationTitle:

Name: _______________________________ _______________________________ Date: _______________ MGMT 414: Final Project Evaluation Title: __________________________________________________________________________ Score RESEARCH and DATA ANALYSIS /30 -Accurately and precisely describes the background and research question. -Discusses how the data was obtained and how variables were chosen, citing sources. -Demonstrates and describes their excel data set, scatter plots, and