I have a hard time doing budgets using excel. can someone help me out with questions on this? I did not do well when I submitted it so I am not sure what I did wrong.

2019SummerFinal Project due 310 - Excel katie, sandage@yahoo.com - AutoSave a File Home A1 0 X Comments Insert Page Layout Formulas Data Review View Help Search Share x 4 Part 1 M N O 45 Advertising $900 per month 46 Utilities $200 per month 47 48 Monthly general and administrative expenses are as follows and are paid in the month incurred if it is a cash expense. 49 Rent $2,000 per month 50 Depreciation $900 for month 52 Required: You must use cell references on the Budget Solution worksheet, by referencing this worksheet that contains the data 53 Prepare the following second quarter budgets and answer the questions listed on the template provided on the BudgetSolution Worksheet. I have adapted the budget model to meet the needs 54 | bolded a line item that is a header and does not need computation on that row 55 Please note the quarter column is for the quarter so not all lines should be added across in the quarter column. When you have beginning and ending inventory or cash balances this is for the u 56 1. Prepare Sales Budget in dollars by month and quarter 57 2. Prepare a merchandise purchase budget by month and quarter in dollars. 58 3. Prepare a Selling Expense Budget, by month and quarter. 59 4. Prepare a General and Administrative budget, by month and quarter 60 5. Prepare a cash budget showing the months and quarter. 616. Based on the quarterly cash budget you prepared, do you have any recommendations 62 on cash management. Discuss the type of business and the cash flow problems a company in this industry might have 63 Type your answer on the budget worksheet where I have set out the question 64 7. Prepare a budgeted income statement for the quarter ending June 30, 20XX 65 You do not need to show monthly columns I entered Sales for you on the income statement 66 8. What do you think about the survivability of this business? 67 9. What if the company finds out the monthly rent will increase to $2,500, what budgets are effected? Why? 69 What is the New Net income(Loss) for the quarter? 19 If you have linked everything correctly, you should only have to change the monthly rent yo on this sheet to determine your answer to the questions asked. Please change the rent back to the original amount of 2,000 before you submit. OverviewFinalProject Part1 Budgetsolution Part 2 Part3 Part 4 + 100% 9:08 PM Type here to search 8/1/2019