Question: Flexible Budgets and Standard Cost Systems Using Excel to prepare a flexible budget performance report Pilchuck Company manufactures tote bags and has provided the following
| Flexible Budgets and Standard Cost Systems | |||||||||
| Using Excel to prepare a flexible budget performance report | |||||||||
| Pilchuck Company manufactures tote bags and has provided the following information for September 2018: | |||||||||
| Actual Results | Static Budget | ||||||||
| Units | 14,000 | 15,000 | |||||||
| Sales Revenue | 560,000 | 540,000 | |||||||
| Variable Costs | 294,000 | 262,500 | |||||||
| Contribution Margin | 266,000 | 277,500 | |||||||
| Fixed Costs | 109,000 | 122,000 | |||||||
| Operating Income | 157,000 | 155,500 | |||||||
| Use the blue shaded areas on the ENTERANSWERS tab for inputs. | |||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
