Management wants to explore the total profit using What If analysis with the data below.Fixed Cost = $10,000 Material cost per toy = $0.15Labor cost per toy = $0.10Vary the Revenue per toy from 0.60 to 1.10 by 0.05, and the labor cost from 0.08 to 0.16 by 0.01When the quantity sold is 27,000 toys, what is the range of profits when the sales price is $$0.70?- $1,090 to $1,340$260 to $2,690$1,610 to $4,040$2,960 to $5,390$530 to $2,960

Total cost = Fixed cost + variable cost*number of units sold Total revenue = Number of units…

Answered: Management wants to explore the total…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

A manufacturing company has the following financial information (in millions of $)Sales $562Cost of goods soldDirect labor 43Purchased materials 267Overhead 35All other costs 142Pretax earnings 75a. What is the profit leverage effect of purchasing in this company?b. What is the percent increase in earnings from a 5 percent savings in purchasing?
You are given the following information: sales, $260; expenses other than depreciation, $140; depreciation expense, $50; marginal income tax rate, 35%. Calculate the net after-tax cash flow effect ofthe preceding information. (Hint: You can use either a direct or an indirect approach to arrive at theanswer.) Round your answer to 2 decimal places.
When we put together a contingency table, we need to think about the calculations and analyses that we wish to perform using the data from the table. 1. tell us a bit more about the type of analyses that could be useful from an operational or marketing perspective? Pick one. 2. Create a contingency table to show the actual probabilities calculations..
CVP Analysis Lawn Master Company, a manufacturer of riding lawn mowers, has a projectedincome for the coming year as follows:Sales $46,000,000Operating expenses:Variable expenses $32,200,000Fixed expenses 7,500,000Total expenses 39,700,000Operating profit $ 6,300,000Required1. Determine the breakeven point in sales dollars.2. Determine the required sales in dollars to earn a before-tax profit of $8,000,000.3. What is the breakeven point in sales dollars if the variable expenses increases by 12%?
Which type of preliminary estimate would be the best in each of the following situations and explain your answer rationale. a. Decide whether it is feasible to proceed with constructing a new small office building. b. Establish the budget for a bond issue to build three new elementary schools. c. Evaluate which of three alternate designs best fits the budget for a new clinic.
I need help with the following questions referring to the image below. Highridge homes has the following payroll information for the week ended Feburary 21: Taxable earnings for Social Security are based on the first $118,500. Taxable earnings for Medicare are based on all earnings. Taxable earnings for federal and state unemployment are based on the first $7,000. Employees are paid time-and-a-half for work in excess of 40 hours per week. Round amounts to the nearest penny. Required 1. Complete the payroll register. The Social Security tax rate is 6.2 percent, and the Medicare tax rate is 1.45 percent. Begin payroll checks with No. 2080. 2. Prepare a general journal entry to record the payroll. The firm's general ledger contains a Wages Expense account and a Wages Payable account. 3. Assuming that the firm has transferred funds from its regular bank account to its special payroll bank account and that this entry has been made, prepare a general journal entry to record the payment of…
McGwire Aerospace expects to have net cash flow of $12 million. The company forecasts that its operating costs excluding depreciation and amortization will equal 75 percent of the company’s sales. Depreciation and amortization expenses are expected to be $5 million and the company has no interest expense. All of McGwire’s sales will be collected in cash, costs other than depreciation and amortization will be paid in cash during the year, and the company’s tax rate is 40 percent. What is the company’s expected sales?
Louis Clark, the new administrator for the surgical clinic, was trying to figure out how to allocate his indirect expenses. His staff was complaining that the current method of taking a percentage of revenues was unfair. He decided to try to allocate utilities expense based on square footage for each department, to allocate administration expense based on direct costs, and to allocate laboratory expense based on direct costs, and to allocate laboratory expense based on tests. What would the results be?
Kraft Bakeries introduced in 2019 a new line of frozen apple pie. For 2019, sales by quarter were asfollows: 11,000 units, 16,000 units, 15,000 units, and 20,000 units. Because of aggressive marketing and promotion, the company expects that sales for each quarter of 2020 will be 25% higher thanthe respective quarter in 2019. The selling price per unit in 2020 is expected to be $4. What are theexpected sales, in units and dollars, for the second quarter of 2020? For the third quarter of 2020?
. Since we now understand that the acronym VRIO stands for 4 four major parts in a structured approach to competitive advantage; these are Valuable, Rare, Imitable, and organized. All play an integral role in helping us managers understand, identify, and evaluate resources. In your own words, how do you think the VRIO Analysis is used to identify, exploit, and evaluate competitive advantage.?
Please solve this. Mega Empire Bhd. is in the inital stages of preparing the annual budget for next year. Danial, has recently joined the company as management accountant and is interested to learn as much as possible about the company’s budgeting process. After the recent meeting with the Sales Manager who is Zack and Aaron as the Production Manager, Danial initiated the following conversation. Danial: Since I am new around here and I am going to be involved with the preparation of the annual budget. I’d be interested to learn how the two of you estimate sales and production numbers. Zack: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then we add the usual dose of intuition to come up with the best forecast we can. Aaron: I usually take the sales projections as a basis for my projections. Of course we have to make estimate of what this year’s ending…
Non-financial performance indicators Identifying the critical success factors of a business is a key element in determining the non-financial performance indicators. Select an organization that you are familiar with, define the organization’s objectives, and identify two (2) critical success factors, and recommend one non-financial performance indicator, which must be measurable (expressed in a numerical formula). Note: the organization could be a business, a restaurant, a shop, a school club, as long as the organization’sobjectives are clear.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

SEE MORE TEXTBOOKS