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