You have a worksheet with company budget projections for the coming year. If you change the...
You have a worksheet with company budget projections for the coming year. If you change the sales projection in Scenario Manager, what is the result?
Select an answer:
-
You will be changing your budget projection worksheet to reflect the changed value.
-
You will be able to view what revenue would be based on that value, without affecting the original data set.
-
You will be able to have Excel automatically update the other budget items, based on the change in sales value.
-
You will be updating the budget projection worksheet with one click to reflect the changed value.
Homework Answers
Answer - You will be changing your budget projection worksheet to reflect the changed value (Option - 1)
why not option 2 - The original data set would be affected when using scenario manager unless and until the original data has been created as a scenario
why not option 3 - Excel would automatically get updated when the sales unit figures are changed irrespective of scenario manager being used
why not option 4 - Using scenario manager changes the data set and does not update the same (i.e. there would be no trial of previously budgeted figures unless a scenario is created for the same)
Sales budget is the most important budget since all the other budgets such as Production budget, Material Purchase budget, cash flow budget, etc are dependent on the sales figure. When the sale projection changes the entire budget changes leading to different levels of production, purchase and cash flow requirements.
Illustration - A simple budget has been prepared for you reference (Assumptions to prepare the budget - one unit of raw material and one hour of labor is required to produce a unit & no opening stock, closing stock to be kept is 200 units & opening cash balance is 10,000 & selling price , labor rate and material price are 55, 10 and 15 respectively)
where 'less sales' is a scenario where we expect sales to be 900 units
where 'more sales' is a scenario where we expect sales to be 1200 units
Comment below if further clarifications are required, please upvote the answer if you found it to fulfill your requirement.
Add Answer to:
You have a worksheet with company budget projections for the
coming year. If you change the...
As part of the process of preparing the master budget for the coming year, you’ve been...
As part of the process of preparing the master budget for the coming year, you’ve been asked to perform what-if analyses, in the form of scenarios, on the original planning assumptions regarding Product A produced by your company. The following are the baseline planning data for the coming year for this product: Sales volume (annual, in units) 2,500 Selling price per unit $ 1,500 Variable cost per unit $ 1,000 Fixed costs (per year) $ 200,000 Required: 1. Based on...
Updating a Dictionary When working with lists, you probably noticed that you can change the value...
Updating a Dictionary When working with lists, you probably noticed that you can change the value at a given index with a simple assignment statement. So, for example, the following code replaces the first element of lst with 42: lst[0] = 42 You can update the value for a given key in a dictionary in the same way. The general syntax for this is: d[key] = value This is also how you insert new key/value pairs to a dictionary; if...
SPU, Ltd., has just received its sales expense report for January, which follows. You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming
SPU, Ltd., has just received its sales expense report for January, which follows. ItemAmountSales commissions$430,500Sales staff salaries88,400Telephone and mailing51,000Building lease payment50,000Utilities16,100Packaging and delivery74,000Depreciation38,750Marketing consultants61,190You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: Sales volume is expected to increase by 14 percent.Sales prices are expected to decrease by 10 percent.Commissions are based on...
You must incorporate as many formulas as necessary so that the worksheet automatically updates when the...
You must incorporate as many formulas as necessary so that the worksheet automatically updates when the market rate of interest is changed. Your Excel spreadsheet should work whether your bond results in a discount or premium. I should be able to manipulate certain data, for example, if I change the present value rates or market rate of interest rate, the formulas should still work correctly when determining the present value of the bond. On January 1, 2018, Raymond Corporation sold...
You must incorporate as many formulas as necessary so that the worksheet automatically updates when the...
You must incorporate as many formulas as necessary so that the worksheet automatically updates when the market rate of interest is changed. Your Excel spreadsheet should work whether your bond results in a discount or premium. I should be able to manipulate certain data, for example, if I change the present value rates or market rate of interest rate, the formulas should still work correctly when determining the present value of the bond. On January 1, 2018, Raymond Corporation sold...
Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled...
Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter of 2019: Actual sales for March and budgeted sales for the next four months are as follows: March $120,000 April 150,000 May 160,000 June 100,000 July 110,000 The company's gross profit rate is 44 percent of sales. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month; advertising, $15,000 per...
Goal: Create a worksheet that shows accounts receivable activity for a company. Scenario: You have a...
Goal: Create a worksheet that shows accounts receivable activity for a company. Scenario: You have a summer holiday job with Qantas headquarters in Sydney. Assume that shortly into your employment your supervisor asks you to prepare an Excel spreadsheet that breaks down the month's accounts receivable by customer. She gives you the partial data: Customer ID F01-235-00 F07-988-45 W40-860-91 Customer name Balance of Accounts Receivable at 30 November Shell $20,469 ADI Ltd $18,752 Sky Link $12,287 December sales December collections...
Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled...
Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter of 2019: Actual sales for March and budgeted sales for the next four months are as follows: a. March $120,000 150,000 160,000 100,000 110,000 April Мay June July b. The company's gross profit rate is 44 percent of sales. c. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month;...
I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and...
I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and sells high quality certified sustainable coffee beans. The final one pound bags of roasted whole coffee beans has two direct materials – coffee beans and packaging. GBCoffee is preparing budgets for the fourth quarter ending December 31, 2019. For each requirement below prepare budgets by month for October, November, and December, and a total budget for the quarter. 1. The previous year’s sales for...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
You must incorporate as many formulas as necessary so that the worksheet automatically updates when the market rate of interest is changed. Your Excel spreadsheet should work whether your bond results in a discount or premium. I should be able to manipulate certain data, for example, if I change the present value rates or market rate of interest rate, the formulas should still work correctly when determining the present value of the bond. On January 1, 2018, Raymond Corporation sold...
Goal: Create a worksheet that shows accounts receivable activity for a company. Scenario: You have a summer holiday job with Qantas headquarters in Sydney. Assume that shortly into your employment your supervisor asks you to prepare an Excel spreadsheet that breaks down the month's accounts receivable by customer. She gives you the partial data: Customer ID F01-235-00 F07-988-45 W40-860-91 Customer name Balance of Accounts Receivable at 30 November Shell $20,469 ADI Ltd $18,752 Sky Link $12,287 December sales December collections...
Carter Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter of 2019: Actual sales for March and budgeted sales for the next four months are as follows: a. March $120,000 150,000 160,000 100,000 110,000 April Мay June July b. The company's gross profit rate is 44 percent of sales. c. Monthly expenses are budgeted as follows: salaries and wages, $12,000 per month;...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago