S329 Extend Your Skills EA10-E1 Prepare Budgets and a CVP Analysis for Environmental Adaptations Co. In this case, you will prepare cash and purchases budgets and CVP analyses for Environmental Adaptations Co You will first create a cash budget, adjusting its appearance to facilitate data cami- mation will then create a purchases budget and adjust print settings to ensure readability and ease of use Last you will use Goal Seek and Solver to create three CVP analyses Open EA10-E1-Budget On the Cash Budget tab, create a cash budget based on a beginning cash balance of $10.400 and this data: Quarter 14 $153,000 Quarter 83 $201.300 Quarter 61 $184.000 Quarter #2 $172,000 $14,000 $26 200 $18.500 $700 $13.500 $1,000 $0 $200 $1,100 $800 5900 SO $3200 $0 $900 50 $147.300 $122.600 $141.000 Cash Receipts from In-Store Customer Sales Cash Receipts from Delivery Sales Reduction in Accounts Receivable Interest Received Sale of Furniture Cash Disbursements for Merchandise Purchases Cash Disbursements for Operating Expenses Loan Payments Principal Loan Payments Interest $129,600 $68.100 $51,300 $53,600 $72,000 SO $3,600 $850 $3,600 $850 $3,600 $850 SO Also enter the necessary formulas. Set up the budget to print with narrow margins and in Landscape orientation. Adjust the third line of the header to read For Quarters Ended in 2017. Insert page breaks such that data for each quarter appears on a separate page and use the Print Titles option to display the three-line header and the headers in columns A-B on every printed page. Set the print area to include only the cash data through row 15. Create a horizontal split that displays the itemized cash receipts directly above the itemized cash disbursements (only the split bar between them). On the Purchases Budget tab, create a purchases budget based on this data: Budgeted Cost of Goods Sold Desired Ending Inventory Beginning Inventory $545,000 $35.000 $39,500 S329 Extend Your Skills EA10-E1 Prepare Budgets and a CVP Analysis for Environmental Adaptations Co. In this case, you will prepare cash and purchases budgets and CVP analyses for Environmental Adaptations Co You will first create a cash budget, adjusting its appearance to facilitate data cami- mation will then create a purchases budget and adjust print settings to ensure readability and ease of use Last you will use Goal Seek and Solver to create three CVP analyses Open EA10-E1-Budget On the Cash Budget tab, create a cash budget based on a beginning cash balance of $10.400 and this data: Quarter 14 $153,000 Quarter 83 $201.300 Quarter 61 $184.000 Quarter #2 $172,000 $14,000 $26 200 $18.500 $700 $13.500 $1,000 $0 $200 $1,100 $800 5900 SO $3200 $0 $900 50 $147.300 $122.600 $141.000 Cash Receipts from In-Store Customer Sales Cash Receipts from Delivery Sales Reduction in Accounts Receivable Interest Received Sale of Furniture Cash Disbursements for Merchandise Purchases Cash Disbursements for Operating Expenses Loan Payments Principal Loan Payments Interest $129,600 $68.100 $51,300 $53,600 $72,000 SO $3,600 $850 $3,600 $850 $3,600 $850 SO Also enter the necessary formulas. Set up the budget to print with narrow margins and in Landscape orientation. Adjust the third line of the header to read For Quarters Ended in 2017. Insert page breaks such that data for each quarter appears on a separate page and use the Print Titles option to display the three-line header and the headers in columns A-B on every printed page. Set the print area to include only the cash data through row 15. Create a horizontal split that displays the itemized cash receipts directly above the itemized cash disbursements (only the split bar between them). On the Purchases Budget tab, create a purchases budget based on this data: Budgeted Cost of Goods Sold Desired Ending Inventory Beginning Inventory $545,000 $35.000 $39,500