Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey Of Accounting

Authors: Thomas Edmonds, Philip Olds, Frances McNair, Bor-Yi Tsay

1st Edition

0073526770, 9780073526775

More Books

Students also viewed these Accounting questions