Can you please show me all your calculations. There should be formulas references for the different worksheets. Also, there should be a couple of VLookup functions on one of the worksheet. Also, can you use the information from these two photos on the top to help figure out the formulas to add to the different worksheets on Excel. Can you check the calculations in the gray on each worksheet on Excel? I made formulas in the gray cells.

the Operating Btheir annual budgeting process. You need to You are helping Bandit's Magic Shop with their create a master budget for the company's 2019, first quarter's operations February, March). hopes will contribute capital to his business. Bandit's sells magic trick kits. This budget is for potential investors (friends of Bandit), whom he (Januany 1. The folowing is information from the November and December budgets November $210,000 $6,300 $14,500 $10,500 $196,000 700 magic kits December $253,000 $7,590 $14,500 $12,650 $210,000 800 kits Credit Saies Misc Purchases Inv magic 2. You have obtained estimates for a sales forecast from Bandit, the store manager and the head sales clerk. (note these are three separate forecast, do not add them together) 9,500 8,500 7,000 Expectations are for sales to increase 5% in February and decrease 2% in March Sales forecast for January (units) Head Sales Clerk Bandit Store Manager (compared to February sales). Round to nearest ten units for sales units. The kits sell for $60 each 3. Typically 30% of sales are made in cash and 70% are paid in credit. Bandit's expects to collect credit sales as follows: 10% in the month of the sale, 60% in the month following the sale, and 30% two months following the sale. Assume there will not be any bad debt Bandt's would like to maintain an ending inventory balance of 10% of next month's sales unit. Each kit cost $28.00 to buy wholesale. They purchase all inventory on account. They pay 60% of their purchases in the month of purchase and 40% the month after purchase. April sales are budgeted to be 9,000 units. 4. 5. They will have the following expenses a. Insurance $150 per month b. Licensing fees-$160 per month C. Supplies-2% of total monthly sales d. Advertising-$1250 per month Payroll expense-$14,500 per month Miscellaneous expenses-1.5% of total monthly sales f. 6. Bandits has decided that they need a new computer system and expects to buy t the beginning of January. The equipment will cost $10,000 and paid in cash