Explain the major components, advantages, and disadvantages of a master budget.
Assess the risks associated with sales forecasting.
Construct an activity-based flexible budget.
You are the analyst for Guillermo Furniture Store. You are asked to revise the store's flex budget by using Excel. Assume Guillermo continues doing business as is.
Create a revised flex-budget in a Microsoft Excel spreadsheet for the Guillermo Furniture Store.© BrainMass Inc. brainmass.com April 3, 2020, 9:30 pm ad1c9bdddf
I put the discussion on a separate tab. You now have two flexible budgets. One with the original budget units changed and another with utilities changed to be more activity-based flexible budget. (Note that this does not re-format into a contribution margin income statement format which separates variable from fixed costs.)