Question

Excel with formulas please and thank you!

ProChem, Inc., produces chemicals for large biotech companies. It has the following data for manufacturing overhead costs during August 2017: Variable Fixed 35,000$ 16,500 15,200 16,000 Actual costs incurred Costs allocated to products Flexible budget Actual input x budgeted rate 31,500 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong Requirement 5 Fill in the blanks on the ENTERANSWERS tab. Use F for favorable and U for unfavorable: a. For variances with a zero amount, leave the box empty; do not select a label or enter a zero. b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when describing the variances 1 Ja. For variances with a zero amount, leave the box empty, do not select a label or enter a zero. b. Use the ABS function when calculating variances, and use the drop-down selections for F or U when 2Ц describing the variances. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from 3 the Instruction tab you will be marked wrong.) Variable F/U Fixed F/U 6 (1) Spending variance 7 (2) Efficiency variance 8 (3) Production-volume variance 9 (4) Flexible-budget variance 10 (5) Underallocated (overallocated) manufacturing overhead 12 13 15

Answer 1

Solution Given daic Aetual costs incumed 3SouD Cost allecated to pru36 o0o Fleribe tudget ovo Aca inpt xlaudgeted yte JSoD. Spending ovance achual costs - Ackial inet arefose, the. Spending ina variance of vaviable. Cesh i Tlare fose, the efpiiener vamence

Flexible Audget- urrianceza pending variax+Híkny win Twere fere the sterbe uetvariance a of vanakle budget nnance of, 3 m . s the difference The ple지 ble en variable Cosk of 누lSCOD and -the-rouble bude aable costs of Solve

Tn (ave of fixed cots. Че ferible budget vanance is the disfesence etee the tha ackeas tixed fleible buidget l6 SoD and the. vancbe red Costs a Ller cots alratecd

ariance cantte dchon volume wiance en c< -the- Sane-as cest s OveN head Fixed 'btJ le the- is urde nlated fixed Costs

vemable Spending vamamae van^ance Efficiency Never Never SOD