A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.

A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 32P

See similar textbooks

Similar questions

Struggling with answering this question A manufacturer produces three types of humidifiers. The retail price of Humidifier Regular (HR) is $60 with variable costs of $20. Humidifier Advanced (HA) sells for $200 for its advanced features. This model’s variable costs are $80. Humidifier Simple (HS) is a simplified version and only sells for $25 with variable costs of $15. The manufacturer has machines and facilities worth $320,000 annually. The sales data show that 1000 units of HR, 2000 units of HA, and 10,000 units of HS was sold last year. Calculate the break-even point of the firm. The firm has some idle capacity at these volumes and chooses to cut the selling price of HR from $60 to $45, believing that its sales volume will rise from 1000 units to 2500 units. What is the revised break-even point?
You work for a small retail store. You must decide how many cases of kombucha to order. Twenty cases fit on a pallet and because of shipping costs, orders must be placed in multiples of 20. You can either order 20, 40, 60, 80 or 100 cases. Each case costs $15. If you order more than 1 pallet, you receive a discount of 5% per additional pallet ordered (2 pallets would be 5%, 3 would be 10%, etc). The cases can be sold for $25 each. Any that are left unsold can be sold to a discount store for $10. Your records suggest that the probability that you will sell 25 cases is 20%, 45 cases is 45%, 65 cases is 20% and 85 cases is 15%. a) Construct a payoff table to provide reflect the decisions and outcomes What would be your decision based on each of the following? Maximin Maximax Minimax regret Expected value Overall - what would you do? Why?
Product K was introduced to the market some time ago and is now about to enter the maturity stage of its life cycle. The maturity stage is expected to last for ten weeks. Each unit has a variable cost of $38 and takes one standard hour to produce.The Managing Director is unsure which of four possible prices the company should charge during the next ten weeks. The following table shows the results of some market research into the level of weekly demand at alternative prices:Selling price per unit ($) 100 85 80 75Weekly demand (units) 600 800 1,200 1,400REQUIREDWhich one of the four selling prices should be charged for Product K in order to maximize its contribution during its maturity stage?
4. A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are $500 per print run, with each copy printed costing an additional $0.40. If C(q) is the cost function (in $) of the price of the print run as a function of copies printed, what is the formula for C(q)? Select one: a. C(q) = 500 + 0.4q b. C(q) = 500q + 0.4 c. C(q) = (500 + 0.4)q d. C(q) = 500 - 0.4q e. C(q) = 500q - 0.4 5. A hot dog vendor sells an average of 50 hot dogs during a Little League baseball game. If the sales are Normally distributed with a standard deviation of 7 hot dogs, what is the probability the vendor will sell between 45 and 65 hot dogs? Select one: a. 74.50% b. 92.36% c. 99.78% d. 174.50% e. 2.14 f. -0.71 g. 0.71
Month Sales January 250 February 350 March 240 April 260 May 280 June 330 July 220 August 310 September 235 October 300 November 240 December 230 A.What is the value of MSE (mean squared error)? The answer is . (Make sure no decimal place and no comma. EX: 1234) B.What is the optimal alpha value to minimize inaccuracy? The answer is . (Make sure two decimal places.)
Explain the 4V-model and some examples of the implications they have for each V. What can the model be used for?
Zara stores in the United States stocks a particular type of designer denim jeans in the United States. It stores 500 pairs of jeans each month from its two suppliers. The Hong Kong supplier charges Zara $11 per pair of jeans, and the Colombian supplier charges $16 per pair (and then Zara marks them up almost 1,000%). Although the jeans from Hong Kong are less expensive, they also have more defects than those from Colombia. Based on past data, Zara estimates that 7% of the Hong Kong jeans will be defective compared to only 2% from Colombia and Zara does not want to import any more than 5% defective items. However, Zara does not want to rely on a single supplier, so it wants to order at least 20% from each supplier every month. A. Formulate a linear programming model for this problem. B.Solve the linear programming model graphically. Use either iso-line or corner point method. How many of each should Zara buy? C. How much will Zara pay for them? D. If the Hong Kong supplier were able to…
Zara stores in the United States stocks a particular type of designer denim jeans in the United States. It stores 500 pairs of jeans each month from its two suppliers. The Hong Kong supplier charges Zara $11 per pair of jeans, and the Colombian supplier charges $16 per pair (and then Zara marks them up almost 1,000%). Although the jeans from Hong Kong are less expensive, they also have more defects than those from Colombia. Based on past data, Zara estimates that 7% of the Hong Kong jeans will be defective compared to only 2% from Colombia and Zara does not want to import any more than 5% defective items. However, Zara does not want to rely on a single supplier, so it wants to order at least 20% from each supplier every month.a. Formulate a linear programming model for this problem. b. Solve the linear programming model graphically. Use either iso-line or corner point method. How many of each should Zara buy? c. How much will Zara pay for them? solve in excel Speak Speak
Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup oflemonade is $0.20.a. Given her other assumptions, what level of sales volume will enable Julie to break even?b. Given her other assumptions, discuss how a change in sales volume affects profit.c. Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit.d. Use Excel’s Formula Auditing tools to show which cells in your spreadsheet affect profit directly.
Irwin’s sells a particular model of fan, with most of the sales being made in thesummer months. Irwin’s makes a one-time purchase of the fans prior to eachsummer season at a cost of $40 each and sells each fan for $60. Any fans unsoldat the end of the summer season are marked down to $29 and sold in a special fallsale. Virtually all marked-down fans are sold. The following is the number of salesof fans during the past 10 summers: 30, 50, 30, 60, 10, 40, 30, 30, 20, 40.a. Estimate the mean and the variance of the demand for fans each summer.b. Assume that the demand for fans each summer follows a normal distribution,with mean and variance given by what you obtained in part (a). Determine theoptimal number of fans for Irwin’s to buy prior to each summer season.c. Based on the observed 10 values of the prior demand, construct an empiricalprobability distribution of summer demand and determine the optimal numberof fans for Irwin’s to buy based on the empirical distribution.d. Based on your…
Which of the following is NOT a determinant of the demand for good X?
Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…