Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NEED HELP WITH 2 , 3 , AND 4 . See tha shel Budget For the first month of operation the partners have $ 1
NEED HELP WITH AND
See tha shel Budget" For the first month of operation the partners have $ for operating and other experises. Using a formula in cell B show the dollar amount that would be budgeted for weekday sales if of The $ budget went into weekday sales. Again using a formula, in cell B show the dollar amount that would go into weekend sales if the remainder of the $ went into weekend sales. Use relative references in cells and
Assume that in month the partners have the same budget of $ and wish to divide up the budget for future months using the same proportions as in month For month create formulas for the dollar amounts of the budget for weekday and weekend sales and place your formulas in cells C and C Use one $ in your formula in such a way that the formulas could be copied from month to month 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 to E
Now the partners which to divide the $ in total costs across categories: supplies, and wages & utilities, as shown on rows and They think that of the $ in costs will go to supplies, and the remainder will go to wages and utities. In cell B create a formula that accomplishes things: find the dollar amount of the $ in costs from cell B 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 in such way that it can be copied to all months within the Supplies category, and can be copied to the other category in cell B such that only the portion or 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 $ for operating and other expenses. Using a formula in cell B show the dollar amount that would be budgeted for weekday sales if of the $ budget went into weekday sales. Again using a formula, in cell B show the dollar amount that would go into weekend sales if the remainder of the $ went into weekend sales. Use relative references in cells B and B
Assume that in month the partners have the same budget of $ and wish to divide up the budget for future months using the same proportions as in month For month create formulas for the dollar amounts of the budget for weekday and weekend sales and place your formulas in cells C and C Use one $ in your formula in such a way that the formulas could be copied from month to month 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 to E
Now the partners which to divide the $ in total costs across categories: supplies, and wages & utilities, as shown on rows and They think that of the $ in costs will go to supplies, and the remainder will go to wages and utilities. In cell B create a formula that accomplishes things: find the dollar amount of the $k in costs from cell B 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 in such a way that it can be copied to all months within the Supplies category, and can be copied to the other category in cell B such that only the portion or has to be changed. Use as few $ as necessary. Make sure Excel is understanding your math correctly.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started