Complete Budgets and a CVP Analysis for Gary’s Housewares

In this exercise, you will create budgets and perform CVP analyses for Gary’s Housewares. You will first create a cash budget, adjusting settings to allow for efficient data examination. You will then create a purchases budget and adjust print settings. Lastly, you will perform CVP analyses using Goal Seek and Solver.

1. Open EA10-A2-Budget from your Chapter 10 folder and save it as: EA10-A2-Budget-[YourName]

2. On the Cash Budget tab, enter 47200 as the beginning cash balance for the first quarter