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

���������� � ��� �� ���� ����������������������������������� ���!�����”#$��� ��%�&�'()�*+*,�”-,.�/%01��������

���������� � ��� �� ���� ����������������������������������� ���!�����”# $��� ��%�&�'()�*+*,�”-,.�/%01�������� ��02!�3)�*+*,�’*-++�0%#� 45678�45698�456:;<=>?@A�BCDEF�EGH�ICDJFEKLIM�NOOJCO�ICFEKC�KL�HNPPCICGQCO�NG�FERO�EGHICDJFEKNLGO�PLI�SLKT�HLUCOKNQ�EGH�UJFKNGEKNLGEF�QLUVEGNCOWXYZ[\]̂[_̀YZa�bc�d�efghigg�jkclmcl�nkopq�rdrmos�ptqjuqq�vkn�rkwtltjdws�wmxdws�dcp�mlvtjdwtqqumq�jdc�dyymjl�lvm�ytcdcjtdw�dcp�zuqtcmqq�krmodltkcq�ky�d�jk{rdc|}�~kn�pkmqlvtq�t{rdjl��korkodlm��kjtdw��mqrkcqtztwtl|�������djlt�tltmq�dcp�~u{dc�mqkuojmq��~���pmrdol{mclq������EGH��JIGNKNG�EIC�IC�JNICHW��GQFJHC�E�UNGNUJU�LP���ICPCICGQCOW�G�KTC��OONDGUCGK�HILVSL���VFCEOC�EKKEQT�MLJI�VEVCI�EO�E�PNFC��HL�GLK�QLVM��VEOKCW����������������������������� ¡�¢£¤�¥¦¤�§̈ ©�ª�«¬­®̄ ©̈°±

See doc���������� ��� � ��� ���������� ��������������� ���!”#$”% &�” ($ �)(#�%%$* %+ �),”�%�”-./)$ +” 0 1 223 4546 22768 90:; �’

See doc ���������� ��� � ��� ���������� ��������������� ���!”#$”% &�” ($ �)(#�%%$* %+ �),”�%�”-. /)$ +” 0 1 223 4546 22768 90:; �’ (‘$ +” :<, =3 4546 24755 :0. >?@AB >?@CB >?@DEFGHIJK LMNNOPOQR STURTPVU WOPXWOSRMYOX ZN V PO[MZQ SVQ M\WVSR XOYOPVU VXWOSRXZN V SZ\WVQ]̂X [UZ_VU _TXMQOXX ZWOPVRMZQX̀ abcd effgh