A large catalog merchandiser is planning to have a special furniture promotion a year from now....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A large catalog merchandiser is planning to have a special furniture promotion a year from now. To do this, the company must place its order for the furniture now. It plans to sign a contract with the manufacturer for 2500 chairs at a cost of $175 per unit. The promotion will last for eight weeks. Marketing research suggests that the demand for the chairs during the first eight weeks has a uniform distribution between 1000 and 3000 units, and the initial price during the first eight weeks is a triangular random variable between $200 and $300 with a peak value at $250. After the first eight weeks, all remaining units will be offered for sale at half the initial price. • Perform an Excel spreadsheet simulation with 5000 replications; • Estimate the mean profit; compute a 90% confidence interval for the mean profit and a 90% prediction interval for the profit; • Estimate the probability of having negative profit, and construct a 90% confidence interval for this probability. A large catalog merchandiser is planning to have a special furniture promotion a year from now. To do this, the company must place its order for the furniture now. It plans to sign a contract with the manufacturer for 2500 chairs at a cost of $175 per unit. The promotion will last for eight weeks. Marketing research suggests that the demand for the chairs during the first eight weeks has a uniform distribution between 1000 and 3000 units, and the initial price during the first eight weeks is a triangular random variable between $200 and $300 with a peak value at $250. After the first eight weeks, all remaining units will be offered for sale at half the initial price. • Perform an Excel spreadsheet simulation with 5000 replications; • Estimate the mean profit; compute a 90% confidence interval for the mean profit and a 90% prediction interval for the profit; • Estimate the probability of having negative profit, and construct a 90% confidence interval for this probability.
Expert Answer:
Answer rating: 100% (QA)
Furniture Promotion Simulation with Excel Heres how to set up a simulation in Excel to analyze the furniture promotion 1 Setting Up the Spreadsheet Column A Demand Use the RANDBETWEEN function to gene... View the full answer
Related Book For
Business Ethics A Stakeholder And Issues Management Approach
ISBN: 9781523091546
7th Edition
Authors: Joseph W. Weiss
Posted Date:
Students also viewed these accounting questions
-
How does an operating budget work to discipline a firm's management? What are the elements of a budget? How are budgets constructed? What is "Variance Analysis" and how is it used?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Calculate the weighted average cost of capital for Genedak-Hogan for before and after international diversification. Did the reduction in debt costs reduce the firm's weighted average cost of...
-
As a practicing engineer in manufacturing, why would you be interested in the shape of the curve shown in Fig. 7.7? Explain.
-
What was the strategy that Alfred Sloan developed to given GM a competitive advantage over Ford and why was it successful? General Motors (GM) was once the largest and most profitable industrial...
-
A motor tractor is bought for 6,000. It will be used for three years, and then sold back to the supplier for 3,072. Show the depreciation calculations for each year using (a) the reducing balance...
-
(One Temporary Difference, Tracked for 4 Years, One Permanent Difference, Change in Rate) The pretax financial income of Truttman Company differs from its taxable income throughout each of 4 years as...
-
On March 1, Dover Manufacturing Ltd. purchased a factory with a lot of land and a machine for $9,717,500. Dover paid legal fees of $2,500 for this purchase, renovation costs on the building of...
-
Explain how each of the traditional advertising executional frameworks noted. Or not related to the international advertising executional frameworks.
-
20 Hour Fitness sells 2 year gym fitness memberships at Costco for $1,200. On 9/21/20 - Dave purchased a 2 year membership at Costco and received a voucher for a two hour membership at 20 hour...
-
Shaw Drumgold was convicted and imprisoned for murder of a 12-year old girl. The key witness against him, Ricky Evans, a homeless man, was given cash, meals and housing at a local hotel for several...
-
What are two DNA evidence resulting in wrongful conviction? What caused this? 2. How reliable is DNA evidence? 3. What problems does DNA evidence present? 4. Do you think DNA evidence is well...
-
In a typical tort lawsuit, the injured party is the plaintiff who brings suit against a defendant who is allegedly liable for causing that harm. However, that defendant might be able to lessen...
-
International and operational law are extremely important legal areas for servicemembers. The laws of war and rules of engagement set forth rules that servicemembers follow while deployed. One such...
-
A 16-year-old (herinafter 16YO) spends a day at the mall and, without permission, takes her mother's charge card to use. 16YO buys some clothing, coffee, and lunch with the charge card. Then she...
-
Compute the present value of $700 paid in three years using the following discount rates: 5 percent in the first year, 6 percent in the second year, and 7 percent in the third year. (Do not round...
-
"Standard-cost procedures are particularly applicable to process-costing situations." Do you agree? Why?
-
Identify two major trends in the changing demographics of the workforce. Include a trend that you as a student or employee could be or are now affected by.
-
Do you believe most CEOs in U.S. companies are overpaid and underperform? Explain. What pay or performance criteria do you believe should be used for top-level officers in publicly traded companies?...
-
I am a project manager who supports corporate-citizenship-funded programs for our large insurance company. I am responsible for helping choose proposals to support for environmental, community...
-
You are to enter up the sales journal from the following details. Post the items to the relevant accounts in the sales ledger and then show the transfer to the sales account in the general ledger....
-
Enter up the sales journal from the following, then post the items to the relevant accounts in the sales ledger. Then show the transfer to the sales account in the general ledger. 19X8 Mar 1 Credit...
-
J Fisher, White House, Bolton, is selling the following items, the retail prices as shown: plastic tubing at 1 per metre, polythene sheeting at 2 per length, vinyl padding at 5 per box, foam rubber...
Study smarter with the SolutionInn App