Access Millions of academic & study documents

Student excel intro cap1 year end report

Content type
User Generated
Showing Page:
1/9

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/9

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/9

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 9 pages?
Access Now
Unformatted Attachment Preview
Author: 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. New Perspectives Excel 2019 | Module 3: SAM Project 1b MedSight Instruments PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS 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. f the file from MedSight Auditory Instruments Unit Sales Projections Five-year growth estimates 2021 2022 2023 2024 2025 4% 10,000 10,400 10,816 11,249 11,699 8% 10,000 10,800 11,664 12,597 13,605 12% 10,000 11,200 12,544 14,049 15,735 16% 10,000 11,600 13,456 15,609 18,106 20% 10,000 12,000 14,400 17,280 20,736 24% 10,000 12,400 15,376 19,066 23,642 28% 10,000 12,800 16,384 20,972 26,844 MedSight Auditory Instruments Vendor Cost Per Unit $ $ $ $ 47.48 52.12 45.98 51.36 $ $ $ 49.24 Average cost 52.12 Highest cost 45.98 Lowest cost Selected vendor Cost Analysis InStar Global Diamonte Manufacturing Laser BioMedical Tanaka Innovations Laser BioMedical Shipping Cost Per Unit $ $ $ $ 8.12 8.22 7.98 8.43 $ $ $ 8.19 8.43 7.98 Selected shipper ments hipping Cost Per Unit COM Shipping SafeCargo Liu-Chen Logistics Johansen Maritime Average cost Highest cost Lowest cost Liu-Chen Logistics MedSight Auditory Instruments Profit Projections Five-year estimates Unit Projections Vendor cost Sales price Shipping cost 2021 sales units $ $ $ 45.98 125.00 7.98 10,000 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4