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%
2021 10000 10000 10000 10000 10000 10000 10000
2022

Cost Estimates

Scrub Jay Peripherals
Cost Estimates
Manufacturing Cost Per Unit Shipping Cost Per Unit
$ 28.02 Vendor 1 $ 6.18 Shipper 1
$ 26.80 Vendor 2 $ 6.22 Shipper 2
$ 31.15 Vendor 3 $ 5.83 Shipper 3
Average Average
Maximum Maximum
Minimum Minimum
Manufacturing candidate Shipping candidate

Profit Projections

Scrub Jay Peripherals
Profit Projections
Sales Projections Timeline
Manufacturing cost $ 26.80 Current date
Sales price $ 75.00 Launch 11/26/21
Shipping cost $ 5.83 Factory work days to market
2021 sales units 10,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

  his week’s nonverbal communication discussions review body language. From a cultural lens, consider how body language during a video conference could

  his week’s nonverbal communication discussions review body language. From a cultural lens, consider how body language during a video conference could be misinterpreted or unintended behavior could be considered distracting. In a 1- to 2-minute video response, Explain the value of nonverbal communication in a virtual setting. Explain how nonverbal cues and atmospherics (room environment) can impact effective

  When working interculturally, gestures and body language may get misinterpreted. When multiple cultures interact, it is important to recognize that

  When working interculturally, gestures and body language may get misinterpreted. When multiple cultures interact, it is important to recognize that gestures or types of nonverbal communication may have different meanings in the various cultures. Therefore, participants who engage in a communication process must be aware that difficulties may arise when gestures are

SEE ATTACHED TCOB Graduate Studies Discussion Rubric Criteria No Submission 0 points Novice (Criterion is missing or not in evidence) 1-13

SEE ATTACHED TCOB Graduate Studies Discussion Rubric Criteria No Submission 0 points Novice (Criterion is missing or not in evidence) 1-13 points Basic (works towards meeting expectations; performance needs improvement) 14-16 points Proficient (meets expectations; performance is satisfactory) 17-18 points Exemplary (exceeds expectations; performance is outstanding) 19-20 points Support of

See instructions Use the globalEDGE website (globaledge.msu.edu) to complete the following exercise: The Global Financial Stability Report is a

See instructions Use the globalEDGE™ website (globaledge.msu.edu) to complete the following exercise: The Global Financial Stability Report is a semiannual report published by the International Capital Markets division of the International Monetary Fund. The report includes an assessment of the risks facing the global financial markets. Locate and download the

Instructions and details are attached. HW5 – Analyzing the Performance of Your Dollar-Cost Averaging (DCA) Cryptocurrency Portfolio

Instructions and details are attached. HW5 – Analyzing the Performance of Your Dollar-Cost Averaging (DCA) Cryptocurrency Portfolio Assignment Instructions: Overview: Throughout the term, you have been implementing a dollar-cost averaging (DCA) strategy by investing $1 daily in Bitcoin (BTC) and Ethereum (ETH), or in a diversified portfolio of cryptocurrencies if you