Please answer the excel portion of the project. They are formulated in data so please don’t…

Please answer the excel portion of the project. They are formulated in data so please don’t… 1 answer below » Please answer the excel portion of the project. They are formulated in data so please don’t change matadata of the excel. I have attached both the instruction and the excel portion. Please help Document Preview: 2021049532

2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

2027049532

4944023.248780488
0

410
0

2027049532
0

10862771

20690.992380952383
0

525
0

10862771
0

842691

4.1572294445540959E-4

842691
0

2021049532

0.997040032862897

2021049532
0

1250000
1250000
0

406 View complete question » Please answer the excel portion of the project. They are formulated in data so please don’t change matadata of the excel. I have attached both the instruction and the excel portion. Please help Document Preview: 2021049532

2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

2027049532

4944023.248780488
0

410
0

2027049532
0

10862771

20690.992380952383
0

525
0

10862771
0

842691

4.1572294445540959E-4

842691
0

2021049532

0.997040032862897

2021049532
0

1250000
1250000
0

4061054526
4061054526
0

2310000
0.46528357681661869
0

4964714.2411614405

19318.18181818182

44

850000
850000
0

1530000

1750000

635000
635000
0

1115000
1115000
0

4910000
2600000.4652835769
0

4058454525.5347166
0
0
0
0
0
0
0
0
0
0
0
0

480000
0

4600000

950000
0

140000
3.0245023998210861E-3

6170000
6170000
0

4052284526
4052284525.5347166
0

-1215685357.6604149
0
0
0
0
0
0
0
0
0
0
0
0

2836599167.8743019
0
0
0
0
0
0
0
0
0
0
0
0

0

2836599167.8743019
0
0
0
0
0
0
0
0
0
0
0

File:
Tab: Century Schoolbook,Bold”Page of Arial,Bold” 4DRAFT
Totals
Advertising
Internal Rate of Return after tax benefits
Notes
Description
Confidential — Board Members only
Actual
Jan – June 2013
Digital electronic Widgets
Sales of replacement parts
Non-warranty service
License fees and Royalties
Total Revenue
Avg sales price $410/unit
Avg sales price $525/unit
4400 part numbers stocked
Avg hourly rate $84.00
Avg compensation with benefits $44.00/hr.
Marketing
Distribution
Customer relations
Production – materials
Production – labor
Production – allocated overhead
allocated at $1.80 per $1.00 of direct labor cost
Selling costs
Total selling costs
does not include advertising
Acquisition Opportunity
Student Name:
Student NetID:
Revenue:
Unit sales
Selling prices
Sales revenue
% of analog sales
Change in unit sales
Change in pricing
Restated
Jan-June
Baseline
Mechanical (analog) Widgets
Period
2 active licenses
Cost of Production and Sales
per unit
N/A
change in cost
change in labor rates
change in labor efficiency
Variable portion of factory overhead
no. labor hours
total units produced
base labor rate per hour
Factory overhead:
change in total unit… Attachments: 3341Instructi….pdf cost-accounti….xlsx View less » Jul 29 2015 04:00 PM