Question: NEED HELP WITH 2 , 3 , AND 4 . See tha shel Budget For the first month of operation the partners have $ 1

NEED HELP WITH 2,3, AND 4.
See tha shel Budget" For the first month of operation the partners have $10,000 for operating and other experises. Using a formula in cell B7, 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 B8 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 B7 and B8.
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 C7 and C8. 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 B9 to E9.
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 utities. In cell B13, create a formula that accomplishes 2 things: find the dollar amount of the $10K in costs from cell B3 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 B13 in such 8 way that it can be copied to all 4 months within the Supplies category, and can be copied to the other category in cell B15 such that only the portion (0.25 or 25%) has to be changed. Use as few $ as necessary. Make sure Excel is understanding your math correctly.
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 B7, 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 B8.
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 C7 and C8. 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 B9 to E9.
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 B13, create a formula that accomplishes 2 things: find the dollar amount of the $10k in costs from cell B3 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 B15 such that only the portion (0.25 or 25%) has to be changed. Use as few $ as necessary. Make sure Excel is understanding your math correctly.
 NEED HELP WITH 2,3, AND 4. See tha shel Budget" For

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!