Description: Two partners have decided to start a food truck business. They think the majority of their sales will be done during weekends, so they've decided to first divide their budget into weekday sales and weekend sales.

See the sheet "Budget." For the first month of operation the partners have $$10,000$ for operating and other expenses. Using a formula in cell B$7,$ show the dollar amount that would be budgeted for weekday sales if $18\%$ of the $$10,000$ budget went into weekday sales. Again using a formula, in cell B$8$ show the dollar amount that would go into weekend sales if the remainder of the $$10,000$ went into weekend sales. Use relative references in cells B$7$ and B$8.$

Assume that in month $2$ the partners have the same budget of $$10,000$ and wish to divide up the budget for future months using the same proportions as in month $1.$ For month $2,$ create formulas for the dollar amounts of the budget for weekday and weekend sales and place your formulas in cells C$7$ and C$8.$ Use one $ in your formula in such a way that the formulas could be copied from month $2$ to month $3,4,$ etc. without having to change the formulas $($within each category$).$

Use the MS Excel addition operator to create a formula to find the total costs $($adding weekday and weekend costs$)$ of running the business in each of these four months. Use references and put your answers in cells B$9$ to E$9.$

$28$

Now the partners which to divide the $$10,000$ in total costs across $2$ categories: supplies, and wages & utilities, as shown on rows $13$ and $15.$ They think that $25\%$ of the $$10k$ in costs will go to supplies, and the remainder will go to wages and utilities. In cell B$13,$ create a formula that accomplishes $2$ things: find the dollar amount of the $$10$k in costs from cell B$3$ that will go to this category, and then divide that dollar amount by the number of days in the month $($to find the average cost per day in that category, for that month$).$ Create the formula in cell B$13$ in such a way that it can be copied to all $4$ months within the Supplies category, and can be copied to the other category in cell B$15$ such that only the portion $(0\mathrm{.}25$ or $25\%)$ has to be changed. Use as few $ as necessary. Make sure Excel is understanding your math correctly.

$29$

$30$

Format all your answers that are dollar values as currency. Make the dollar values from B $7$ to E$9$ have no decimal places and the dollar values from B$13$ to E$15$ have two decimal places.

Create a new sheet and name it "Forecasting." Put this sheet inbetween the "Info and Directions" and "Budget" sheets in this Excel file.