Must use excel to solve it. Thanks aconneCt All applicable Problems in Series A

Question

Must use excel to solve it. Thanks
aconneCt All applicable Problems in Series A are available in Connect Problem 8-18A Flexible budget planning Howard Cooper, the president of Glacier Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal year 2019: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost $60.00 32.00 5.76 3.44 Expected fixed costs Facility maintenance Selling, general, and administrative $320,000 120,000 Required a. Prepare the pro forma income statement that would appear in the master budget if the firm expects b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of to provide 30,000 hours of services in 2019. service hours that the firm can achieve. According to the consultant's analysis, if Glacier charges customers $56 per hour, the firm can achieve 38,000 hours of services. Prepare a flexible budget using the consultant's assumption The same consultant also suggests that if the firm raises its rate to $64 per hour, the number of service hours will decline to 25,000. Prepare a flexible budget using the new assumption. Evaluate the three possible outcomes you determined in Requirements a, b, and c and recommend a pricing strategy c. d.

Explanation / Answer

Part-(a),(b), ( C) Master Budget Flexible Budget Flexible Budget Standard cost/Hour 30000 Hour Standard cost/Hour 38000 Hour Standard cost/Hour 25000 Hour Service Revenue $60.00 $1,800,000.00 $56.00 $2,128,000.00 $64.00 $1,600,000.00 Less: Variable Cost Labour Cost $32.00 $960,000.00 $32.00 $1,216,000.00 $32.00 $800,000.00 Overhead Cost $5.76 $172,800.00 $5.76 $218,880.00 $5.76 $144,000.00 Selling,general and administrative Cost $3.44 $103,200.00 $3.44 $130,720.00 $3.44 $86,000.00 Contribution Margin $18.80 $564,000.00 $14.80 $562,400.00 $22.80 $570,000.00 Less: Fixed Overhead Facility Maintainance $320,000.00 $320,000.00 $320,000.00 Selling,general and administrative Cost $120,000.00 $120,000.00 $120,000.00 Net Income $124,000.00 $122,400.00 $130,000.00 (d). As per above computation its recommended to follow Pricing strategy of $64 per Hour and number of Service hour will be 24000 Hour

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.