NP_EX365_2021_CT3c_DaneHaehn_2

xlsx

School

University of Arkansas *

*We aren’t endorsed by this school

Course

003

Subject

Communications

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by MagistrateLark3875

Author: Note New Per

Scrub Jay Peripherals PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS dane haehn e: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from th rspectives Excel 365/2021 | Module 3: SAM Critical Thinking Project 1c

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Scrub Jay Peripherals Sales Projections Yearly Sales Projections (units) Year-over-year growth estimate 5% 10% 15% 20% 25% 30% 35% 2024 10000 10000 10000 10000 10000 10000 10000 2025 10500 10500 10500 10500 10500 10500 10500 2026 10500 10500 10500 10500 10500 10500 10500 2027 10500 10500 10500 10500 10500 10500 10500 2028 10500 10500 10500 10500 10500 10500 10500

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 $ 28.66 Average $ 6.08 Average $ 31.15 Maximum $ 6.22 Maximum $ 26.80 Minimum $ 5.83 Minimum Vendor 2 Shipping candidate Shipper 3 Manufacturing candidate

Scrub Jay Peripherals Profit Projections Sales Projections Manufacturing cost $ 26.80 Current date Sales price $ 75.00 Launch Shipping cost $ 5.83 Factory work days 2024 sales units 10,000 Gross Profit From Sales Projections Year-over-year growth estimate 5% 10% 15% 20% 25% 2024 $ 423,700 $ 423,700 $ 423,700 $ 423,700 $ 423,700 2025 $ 444,885 $ 466,070 $ 487,255 $ 508,440 $ 529,625 2026 $ 467,129 $ 512,677 $ 560,343 $ 610,128 $ 662,031 2027 $ 490,486 $ 563,945 $ 644,395 $ 732,154 $ 827,539 2028 $ 515,010 $ 620,339 $ 741,054 $ 878,584 $ 1,034,424

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Timeline 2/14/2024 11/26/2024 to market 205 30% 35% $ 423,700 $ 423,700 $ 550,810 $ 571,995 $ 716,053 $ 772,193 $ 930,869 $ 1,042,461 $ 1,210,130 $ 1,407,322

NP_EX365_2021_CT3c_DaneHaehn_2

Related Documents