Question

In: Operations Management

Use the excel document found in the Assignments tab to answer the questions below. Part A:...

Use the excel document found in the Assignments tab to answer the questions below.

Part A: (1 mark)

Advent Company wants to introduce a new printer called the Blitzer. The company believes demand will be 10,000 units per year at a price of $50 per printer. Advent would invest $300,000 and requires a 50% return on their investment.

Calculate the target cost per unit for the new Blitzer printer.

Part B: (1 mark)

Growing Inc. manufactures growth charts. Growing Inc. has recently invested in a new machine that can individualize the picture displayed on the growth chart. They believe demand for this new type of growth chart will be 50,000 charts per year at $15 per chart. The machine will cost $500,000. They would like to earn 45% on this investment.

Calculate the total target cost for 50,000 units for the new style of growth chart.

Part C:

Talia Corp. produces digital cameras. For each camera produced, direct materials are $27, direct labour is $15, variable manufacturing overhead is $18, fixed manufacturing overhead is $32, variable selling and administrative expenses are $7, and fixed selling and administrative expenses are $22.

Calculate the target selling price assuming that a 40% markup on total per unit cost is required.

Solutions

Expert Solution

Part A: (1 mark)

Advent Company wants to introduce a new printer called the Blitzer. The company believes demand will be 10,000 units per year at a price of $50 per printer. Advent would invest $300,000 and requires a 50% return on their investment. Calculate the target cost per unit for the new Blitzer printer.

Total revenue = 10000 X 50 = $500,000

Investment = $300,000;

50% return on investment = $150,000

So profit = $150,000 = Revenue - costs

i.e. Costs = 500,000 - 150,000 = 350,000

So target cost per unit = 350,000/10,000 = $35

Part B: (1 mark)

Growing Inc. manufactures growth charts. Growing Inc. has recently invested in a new machine that can individualize the picture displayed on the growth chart. They believe demand for this new type of growth chart will be 50,000 charts per year at $15 per chart. The machine will cost $500,000. They would like to earn 45% on this investment. Calculate the total target cost for 50,000 units for the new style of growth chart.

Total revenue = 50000 X 15 = $750,000

Cost of machine = $500,000

45% on this investment = 45% X 500,000 = $ 225,000

Therefore, revenue - cost = profit implies 750,000 - cost = $225,000

Therefore, total target cost = $525,000

Part C: (3 marks)

Talia Corp. produces digital cameras. For each camera produced, direct materials are $27, direct labour is $15, variable manufacturing overhead is $18, fixed manufacturing overhead is $32, variable selling and administrative expenses are $7, and fixed selling and administrative expenses are $22. Calculate the target selling price assuming that a 40% markup on total per unit cost is required.

Direct material = $27

Direct labor = $15

Variable manufacturing overhead = $18

Fixed manufacturing overhead = $32

Variable selling and admin expense = $7

Fixed selling and admin expense = $22

So total cost = $121

Now markup = 40%

Markup % = (selling price - cost)/cost X 100

40 = (x-121)/121X100; let x be selling price

Therefore; x-121 = 40X121/100 = 48.4

Therefore x = $169.4


Related Solutions

On a separate tab of your Excel document you will be answering the questions noted below....
On a separate tab of your Excel document you will be answering the questions noted below. Ensure that your calculations are linked to your financial statement numbers in order to support your conclusions. If other documentation is used to answer the question, please indicate through a detailed reference where this information was obtained/copied. What type of income format(s) is used by these two companies? Identify any differences in income statement format between these two companies. What are the gross profits,...
Answer the following questions and use Excel or this document to show your work. 1. Consider...
Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.
Part I We’ll use the “Debt and Taxes” tab in the Lab 5 Excel Workbook The...
Part I We’ll use the “Debt and Taxes” tab in the Lab 5 Excel Workbook The Economic Data Runs from 1946 (1st year post WW2) to 2016 Note: This issue is tremendously more complicated than the two variables presented here. This is only a partial look at the issue and there is ample room for debate as causes of the issues at hand. 1) Examining the Relationships               Create and copy in the following Charts                              1) Line Chart with...
Use the confusion matrixes to answer the questions below. Record your answers in a word document....
Use the confusion matrixes to answer the questions below. Record your answers in a word document. Explain your responses and include screen shots where requested. A 5000 row dataset was used to build a model to predict if a person would accept a marketing offer for a personal loan (Personal Loan = Yes). It was partitioned into Training, Validation, and Test with the model results above. If you were to decrease the cutoff to 0.3 how would that impact your...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...
Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer. A local pastry shop is planning their next morning’s production. The shop has three main items that they sell: cakes, cupcakes, and cannolis. All of these are made in-house with the shop’s own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flower, 15 g of...
Please use ONLY one Excel file to answer the below questions. ( including the formula using...
Please use ONLY one Excel file to answer the below questions. ( including the formula using for Excel) In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. In April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as the best long-term investment. By contrast, only 91 chose bonds. Compute the...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?...
Read the assignment and answer the questions. You must also upload your Excel file, Word document...
Read the assignment and answer the questions. You must also upload your Excel file, Word document or pdf showing your work. Bodacious Building Co. is considering four different acquisition methods for obtaining pickup trucks. If the contractor’s MARR is 6%, which alternative do you recommend? The alternatives are: Immediate cash purchase of the trucks for $22,500 each, and after five years sell each truck for an estimated $4,900. Lease the trucks for five years for $4,000 per year paid at...
Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use...
Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use the data in “GPS.XSLS” to: Q1. Estimate the parameter p and q in Bass Model. Q2. Compute the time and value of peak sales. Year Sales (00s) 1990 164 1991 276 1992 578 1993 1604 1994 3435 1995 5785 1996 8500 1997 12000 1998 15000 1999 18000 2000 20000 Please show the steps thank you
Use the following information to answer the questions below:
Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: 2016 2017 Sales $ 975,000 $        1,072,500 less Cost of Goods Sold: 325,000 346,125 Gross Profit 650,000 726,375 Operating Expenses 575,000 609,500 Earnings before Interest & Taxes 75,000 116,875 Interest exp 25,000 31,000 earnings before Taxes 50,000 85,875 Taxes 20,000 34,350 Net Income $ 30,000 $              51,525 Balance Sheet info: 12/31/2016 12/31/2017 Cash 60,000 $ 63,600 Accounts Receivable 80,000 $ 84,000 Inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT