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


Question Description:

25

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

Answer

25