COMPLETE BUDGETS AND A CVP ANALYSIS FOR CARA'S PARTY EMPORIUM

In this exercise, you will create budgets and perform CVP analyses for Cara's Party Emporium.

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. Last, you will perform CVP analyses using Goal Seek and Solver.

Open EA$10-$R$2-$Budget from your Chapter $10$ folder.

To begin, you will populate the budget with data and formulas.

On the Cash Budget tab, enter $8500$ in cell J$6.$

Enter the first quarter data:

$\backslash$table$[[$Cell J$8,151000],[$Cell J$9,15000],[$Cell J$10,600],[$Cell J$11,900],[$Cell J$12,0],[$Cell J$13,=$ SUM $($J$8$: J$12)],[$Cell J$15,=$ J$6+$ J$13],[$Cell J$17,116000],[$Cell J$18,5600],[$Cell J$19,3000],[$Cell J$20,700]]$