Canadian motorcycle company
Course:- Operation Management
Reference No.:- EM13834533

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Operation Management

The Canadian Motorcycle Company (CMC) has determined that its customers are very price-sensitive, with the number of motorcycles purchased heavily dependent upon the prices set. The company makes two different styles of bike: the high-end Jet and the lower-end Canuck. Market research has shown that the Jet has a price-demand curve of p = 22,000 - 0.25x, where p represents price and x represents the demand volume. For the Canuck, the curve is p = 18000 - 0.3x. In order to determine profit, CMC will simply take the selling price minus the materials costs. Raw materials for the Jet are $6000 per bike, and they are $5000 per bike for the Canuck. Since CMC hand-builds each bike it makes, the only real constraint for building the bike is the number of manufacturing hours available. CMC has 10,000 hours per month of manufacturing capacity available. A Jet takes 23 hours to manufacture and a Canuck takes 20. CMC also wants to ensure the integrity of each product line, so it will require that a minimum of 100 of each bike should be made each month. Note: All figures are in Canadian dollars. 1. How many of each type of bike should CMC manufacture each month? What will its profit be? 2. Should it drop its minimum limit of 100 of each bike? Why or why not? *** I'm having trouble with the formulas in Excel and setting up the model - Specifically what I may need to type in Excel would be ideal, please! *** 

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Operation Management) Materials
Mister Rogers Industries specializes in manufacturing and selling low-end sweaters – the neighborly sort. Amazingly they manufacture and carry over 450 different types of neig
Is the Japanese work ethic comparable to the American work ethic? Japanese corporations typically involve many more organizational levels and people in the development of impl
Bill and Hillary are friends. Bill has recently retired and now has $450,000 in super. He asks Hillary, an accountant, if he should invest $200,000 of his super funds in Midge
Suppose that chemical X is manufactured using a raw material B that is available from a location called the "mine." Production of one ton of X requires 1/3 of a ton of B. A fi
Robert is repaying a debt with 21 annual end-of-the-year payments of $1300 each. At the end of the 4th year, he makes an extra payment of $2600. He then refinances his loan by
You will create a speech that should be three to five minutes long. You must also have a transcript (print version) of your speech and include a short 75-word reflection state
Describe a non-programmed decision you have made using the rational decision making model. At what point did bounded rationality kick in? What might have happened if you did n
As Manager of Staffing for your organization (or a former employer), you are responsible for filling open positions by seeking highly qualified internal candidates before you