Explore BrainMass

Guillermo Furniture Store Analysis Budget: Revise flexible

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 March 21, 2019, 9:38 pm ad1c9bdddf

Solution Summary

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.)