you must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. . Flexible Budget Performance Report
Yeager Manufacturing Company manufactures baseball gloves. The
company has compiled the following actual and budgeted information
for 2017:
Amount
Actual unit sales during 2017
Budgeted unit sales for 2017 10,357
10,470 Actual results for 2017
Actual sales price per unit
Actual direct materials cost per unit
Actual direct labor cost per unit
Actual factory overhead cost per unit
Actual variable selling expenses per unit
Actual fixed factory overhead
Actual fixed selling and administrative expenses $
$
$
$
$
$
$ 40.00
4.83
7.88
2.49
1.57
119,031.00
49,189.00 Static budget information for 2017
Budgeted sales price per unit
Budgeted direct materials cost per unit
Budgeted direct labor cost per unit
Budgeted factory overhead cost per unit
Budgeted variable selling expenses per unit
Budgeted fixed factory overhead
Budgeted fixed selling and administrative expenses $
$
$
$
$
$
$ 40.00
4.80
7.09
2.02
1.75
119,184.00
49,465.00 4.82685471
7.87757063
2.48537254
1.56962061 4.79919815
7.08999729
2.02222633
1.74915922 Required:
1. Prepare a Flexible Budget Performance Report for 2017
Note* Make sure you state whether variances are favorable, F or
unfavorable, U Use the are (*Note: Your instruc Yeager Manufacturing Company
Flexible Budget Performance Report
For year ended December 31, 2017 Actual
Variance F/U Revenue
Sales
Variable costs
Direct materials
Direct labor
Factory overhead
Total manufacturing costs
Variable selling expenses
Total variable costs
Fixed factory overhead
Fixed selling and administrative expenses
Total fixed costs
Total expenses
Operating income Round all calculations to two decimal pla Use the area below to show your work and calculations.
(*Note: Your instructor may use this area to help review and resolve any incorrect answers) g Company
mance Report
ber 31, 2017 Flexible Budget ations to two decimal places ulations. orrect answers) Static
Variance F/U Budget

• 1492739226-EXCEL_A10_student_name.xlsm

SuperTutor

(15)

Status NEW Posted 21 Apr 2017 01:04 AM My Price 12.00

-----------

Attachments

file 1492739229-Solutions file.docx preview (56 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer