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
-
Recall the eight special extinguishing systems/agents . Briefly describe each, and include an example of a situation where each might be 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...
-
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?...
-
What values of T5 produce a result within the desired tolerance? What is the input tolerance? Suppose the amount of toxin in a culture declines according to Tt+1 = 0.5Tt and we wish to have a...
-
A supermarket chain is interested in exploring the relationship between the sales of its store-brand canned vegetables (y), the amount spent on promotion of the vegetables in local newspapers (x1)...
-
Why has there been increasing recognition of the significance of international accounting diversity?
-
If two firecrackers produce a sound level of 95 dB when fired simultaneously at a certain place, what will be the sound level if only one is exploded?
-
Find the mode of each group of numbers: 1,1,1,1,1,1,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,4,4,4,4,4,4,4,5,5,5,
-
Fourth-Sixth-Twelfth Bank currently pays an annuall dividend of $1.40 per share. After extensive analysis, you forecast that the Bank's stock will continue to pay the $1.40 dividend for four years....
-
A statement reporting the impact of afirm's operating, investing, and financing activities on cashflow over an accounting is the statement of cashflows (A. True, B false)
-
Seaside Service Co. pays salaries monthly on the last day of the month. The following information is available from Seaside for the month ended December 31, 2010. Assume the Social Security tax rate...
-
Outside, Inc., publishes magazines for skiers and hikers. The firm has the following adjusted trial balance at December 31: Required a. Prepare an income statement for the year and a balance sheet as...
-
Prism Business Consultants has three employees a consultant, a computer programmer, and an administrator. The following payroll information is available for each employee: For the current pay period,...
-
When a customer places an order, Custom Cakes requires a deposit equal to the full purchase price. SEO, However, Custom Cakes does not recognize revenue until the completed cake is delivered. During...
-
What does the term debit mean? What does the term credit mean?
-
. Current Attempt in Progress Crane Ltd. owns 154100 shares of Cullumber Ltd. common shares, which are being accounting for by the equity method. On December 15, 2023, when Crane's "Investment ...
-
r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.
-
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?
-
The following information is provided for Shaq Co. for the new product it recently introduced. Total unit cost \($30\) Desired ROI per unit \($10\) Target selling price \($40\) What would be Shaq...
-
Sprague Company is considering developing a new product. The company has gathered the following information on this product. Expected total unit cost Estimated investment for new product Desired ROI...
-
Bristle Brush Company operates in a state where corporate taxes and workers' compensation insurance rates have recently doubled. Bristle's president has just assigned you the task of preparing an...
Study smarter with the SolutionInn App