Tesla has recently set up a Mega factory in China. The factory can produce three models...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tesla has recently set up a Mega factory in China. The factory can produce three models for the Chinese customers: Model X, Model S, and Model C. All three models go through three main steps during the manufacturing process: Battery Manufacturing, Body Stamping, and Final Assembly. All cars share the same battery manufacturing, body stamping, and assembly line capacity. Table 2 summarizes cost and sales data for all three models, and Table 3 shows the available capacity in hours and time required per car for each process. a. Develop a spreadsheet model and use Solver to find the best product mix ( number of cars to make) for Tesla. (25) b. The marketing manager of model C insists that they should make at least 5000 cars of model C. How will you respond to this request? (3) c. What is the maximum number of model C cars that Tesla can make? (2) Submit your excel spreadsheet. Table 2: Cost and Market Data Selling price ($/car) Direct Material Cost ($/car) Labor Csost: Battery manufacturing ($/car) Stamping ($/car) Assembly Line ($/car) Battery Manufacturing Stamping Assembly Line Model X Model S Model C 35,000 38,000, 30,000 20,000 22,000 18,000 Model X Hr/car 2.0 1.5 1.7 1,200 1,500 1,700 Table 3: Labor and Capacity 1,200 1,700 1,900 Model S Hr/car 2.0 1.7 1.9 1,100 1,200 1,500 Model C Total Capacity available Labor Hrs Hr/car 2.5 1.2 1.5 18,000 15,000 16,000 Tesla has recently set up a Mega factory in China. The factory can produce three models for the Chinese customers: Model X, Model S, and Model C. All three models go through three main steps during the manufacturing process: Battery Manufacturing, Body Stamping, and Final Assembly. All cars share the same battery manufacturing, body stamping, and assembly line capacity. Table 2 summarizes cost and sales data for all three models, and Table 3 shows the available capacity in hours and time required per car for each process. a. Develop a spreadsheet model and use Solver to find the best product mix ( number of cars to make) for Tesla. (25) b. The marketing manager of model C insists that they should make at least 5000 cars of model C. How will you respond to this request? (3) c. What is the maximum number of model C cars that Tesla can make? (2) Submit your excel spreadsheet. Table 2: Cost and Market Data Selling price ($/car) Direct Material Cost ($/car) Labor Csost: Battery manufacturing ($/car) Stamping ($/car) Assembly Line ($/car) Battery Manufacturing Stamping Assembly Line Model X Model S Model C 35,000 38,000, 30,000 20,000 22,000 18,000 Model X Hr/car 2.0 1.5 1.7 1,200 1,500 1,700 Table 3: Labor and Capacity 1,200 1,700 1,900 Model S Hr/car 2.0 1.7 1.9 1,100 1,200 1,500 Model C Total Capacity available Labor Hrs Hr/car 2.5 1.2 1.5 18,000 15,000 16,000
Expert Answer:
Answer rating: 100% (QA)
Tesla Production Optimization with Solver in Excel This document outlines a professional approach to optimizing Teslas production mix for their China ... View the full answer
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these economics questions
-
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...
-
You have been recently elected to the position of treasurer on the board of directors for Canoes Are Us, a community-based service and NFPO that provides canoeing lessons and canoe rentals to various...
-
Suppose the money supply is $250 million dollars and the demand for money is given by Qm D = 400 - 40i, where Qm D is in millions of dollars. A. What is the equilibrium interest rate in this economy?...
-
Ladora Construction Company began operations on January 1, 2019, when it acquired $30,000 cash from the issuance of common stock. During the year, Ladora purchased $6,000 of direct raw materials and...
-
Convert each pressure to an equivalent pressure in atmospheres. (a) 736 mmHg; (b) 0.776 bar; (c) 892 Torr; (d) 225 kPa.
-
If the Simplico mine is solved with all parameters remaining the same except that \(u=1.2\) is changed to \(u=1.3\), the value of the lease remains unchanged to within three decimal places. Indeed,...
-
Data Set 9 in Appendix B lists measured cotinine levels from a sample of subjects who smoke, another sample of subjects who do not smoke but are exposed to environmental tobacco smoke, and a third...
-
Question 3 [15 points] Consider the following drawing of a component that is to be manufactured: A 200 B 300 75 200 225 0252 All dimensions in miles C 350 050 2 440 475 125 R25 025 MC 150 50 AB X-Y...
-
If you decided to open a photo studio and printing gallery. You planned to hire workers for financial, photographic, and editing work. Select the software and hardware that you will provide to the...
-
The study of semantics invites us to consider how words and sentences take on meaning. Your text discusses one theory that a word could have meaning based on its reference, but acknowledges that this...
-
what costs does an organisation applying for an Australian financial licence must consider?
-
I need help with that assignment report from Jason Bermiller. I was trying to pay the subscription but my payment is not going through. it states that it would cost $24 per month. Since my debit...
-
Self-Reflection Report (worth 10%) Each student is also required to report indicating what you learned about yourself, your strengths, areas for growth, the impact the assessment had on you, how it...
-
Joseph Sabatino, the head of the corporate finance department, is planning to raise $10 million from the financial market to expand the business operations. Identify four major financial instruments...
-
Suppose you get this information that related to Nevada, and as CFO, you must calculate the overhead cost based on these workflows: Maintenance Cutting Cafeteria Labelling Product Design Marketing...
-
A consumer magazine is evaluating five brands of trash compactors for their effectiveness in reducing the volume of typical household products that are discarded. In the experiment, each block...
-
What are the major differences between using letters of credit and bills of exchange (drafts) as procedure for financing exports and receiving payment?
-
From the perspective of the parent company is it better to use a low export transfer price or a high transfer price? What effect does extent of ownership of the importing unit have on your answer?...
-
How can a company make operational use of the network model and relationship marketing in planning and implementing international marketing programmes?
-
Due to the Covid recession of 2020, the U.S. government budget changed from smaller deficits to very large deficits. What impact would this have on the net exports and private sector balances, all...
-
Verify the likelihood in equation (16.5) for the two-part model. n2. (16.5) -(-)-(-2)/02 L = [] {(p;)" (1 p; )'-'} [[ ( i=1 ri=1
-
Two Population Poissons. We can express the two population problem in a regression context using one explanatory variable. Specifically, suppose that \(x_{i}\) only takes on the values of zero and...
Study smarter with the SolutionInn App