Design a spreadsheet to compute the expected net income from sales for each quarter and for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design a spreadsheet to compute the expected net income from sales for each quarter and for the whole year using the assumptions below. Your manager wants to be able to change any of the assumptions and automatically compute the new expected net income. The sales department has estimated sales unit of 1000 for the first quarter and a 5% increase each succeeding quarter. The sales department plans to sell the product for $18.95 each. Manufacturing has developed an estimate for the cost of goods sold as $12.45 per unit. The advertising department has a tentative contract for $1,000.00 per quarter. The variables (assumptions) to be considered are: first quarter sales, quarterly sales percent increase, selling price (each), cost of goods sold (each), and the quarterly advertising expenses. Notes: Net income = gross income - advertising expense Gross income = revenue - cost of goods sold Revenue unit sales x selling price Design a spreadsheet to compute the expected net income from sales for each quarter and for the whole year using the assumptions below. Your manager wants to be able to change any of the assumptions and automatically compute the new expected net income. The sales department has estimated sales unit of 1000 for the first quarter and a 5% increase each succeeding quarter. The sales department plans to sell the product for $18.95 each. Manufacturing has developed an estimate for the cost of goods sold as $12.45 per unit. The advertising department has a tentative contract for $1,000.00 per quarter. The variables (assumptions) to be considered are: first quarter sales, quarterly sales percent increase, selling price (each), cost of goods sold (each), and the quarterly advertising expenses. Notes: Net income = gross income - advertising expense Gross income = revenue - cost of goods sold Revenue unit sales x selling price
Expert Answer:
Answer rating: 100% (QA)
Computation for net income is shown below Units Per unit rate Amount A B C A B First ... View the full answer
Related Book For
Cost Management A Strategic Emphasis
ISBN: 9781259917028
8th Edition
Authors: Edward Blocher, David F. Stout, Paul Juras, Steven Smith
Posted Date:
Students also viewed these accounting questions
-
FRZN Rubber Inc. has hired your employer to provide some professional consulting. Your group has been assigned to advise the management of FRZN Rubber on some alternative strategies for their coming...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Q3: Prove: For any sets A and B, Ax B = B A ?
-
Go to this Web site and research TWO national stock exchanges of your choice: www.site-by-site.com/exchanges_europe.htm Select a stock company from each nation and write an analysis on them.
-
Indicate the two approaches to presenting consolidated statements.
-
Consider forecasting with the \(A R(1)\) model. a. Use the forecasting chain rule in equation (8.4) to show \[y_{T+k}-\widehat{y}_{T+k} \approx \varepsilon_{T+k}+\beta_{1}...
-
Hertz Corporation is incorporated in the state of Delaware and has its headquarters in the state of New Jersey. Melinda Friend, a California citizen, sued the Hertz Corporation in California state...
-
An aluminum wheel rubs against an aluminum plate in such a manner that there is a 51.0 N force of kinetic friction between them, and the relative speed at which the two surfaces slide over each other...
-
The focus of this project is to create a master budget for the Williams Company based on the companys industry outlook, recent company outcomes, and the companys business rules. You will create a...
-
4. A two-dimensional incompressible source flow of strength A=2 is placed at the origin (0,0) of a Cartesian coordinate (x-y) system. A flow field described by the stream function = xy, is...
-
A big chunk of the savings households up and down the income ladder built up when the pandemic started is still there...[Consumers]will also surely notice that the price of gasoline has...
-
Briefly explain why you would like to be placed with the a internship at the Health Department?
-
What are some best practices for writing clean and maintainable code? Provide examples of code snippets demonstrating these practices.
-
Is optimism bias a good thing, when all else fails, should we lower our standards to be happy? Some people argue that happiness scores, since they are subjective, it has no meanings, some argue that...
-
QUESTION ONE [25] 1.1 For each of the following independent scenarios, use the demand-supply model to motivate your answer. 1.1.1 As the owner/manager of a company, one has to be aware of the effects...
-
Two asteroids of different masses are separated in space by a distance of 5m. Which one (if either) feels a stronger gravitational force due to the other? Or are they the same? Explain your reasoning.
-
In Problem use absolute value on a graphing calculator to find the area between the curve and the x axis over the given interval. Find answers to two decimal places. y = x 3 ln x; 0.1 x 3.1
-
The following data were obtained from the 2016 financial statements for two U.S. automakers (in millions of dollars): Required 1. Calculate and interpret total productivity in dollars for the two...
-
Choose the correct option for the following question Direct materials are Manufacturing Cost Prime Cost Conversion Cost Yes Yes Yes No Yes No Yes No No No a. b. C. Yes No d.
-
Which of the following is not a characteristic of nonfinancial performance quality indicators? a. They relate to physical processes and therefore focus attention on precise problem areas in need of...
-
What other solutions could you see be effective at improving employee motivation and reducing the turnover rate? Why do you believe these solutions would be useful?
-
Should the whole team have decided on the team members schedule accommodations collectively? Why or why not?
-
In what ways do you believe providing special work arrangements or accommodations for employees impacts employee motivation? How does it help? How does it hurt?
Study smarter with the SolutionInn App