Compute the expected net income from sales

Assignment Help Operation Management

Reference no: EM131639106

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 × selling price

Reference no: EM131639106

Questions Cloud

Procedural switching costs-involve lost time and effort : Procedural switching costs—involve lost time and effort.

Distinguish between a manager and a leader : Distinguish between a manager and a leader. What skills do they possess that would contribute to the success of a company.

Prepare the general journal entries for april and may : Use this information to prepare the General Journal entries (without explanation) for April 15 & May 15. If no entry is required then write "No Entry Required"

About advance directives in health information legal class : Mary has recently learned about advance directives in her health information legal class. Where should she begin to prepare such a document?

Compute the expected net income from sales : Design a spreadsheet to compute the expected net income from sales for each quarter and for the whole year using the assumptions below.

Quality-related costs rarely apply to purchasing : Quality-related costs rarely apply to purchasing and customer service departments since these activities are ancillary to manufacturing.

Develop a report that addresses the questions : Develop a report that addresses the questions asked by the top management in relation to both energy

What would happen to the value of kay stock : What would happen to the value of Kay stock upon the announcement of a change in policy? Would it rise or fall by how many million

Prepare the general journal entry to record the retirement : Use this information to prepare the General Journal entry to record the retirement & accrued interest payment of the board

User Account

All Pages