Question

In: Economics

EXCEL problem Your company manufactures TVs, stereos and speakers, using a common parts inventory of Chassis...

EXCEL problem

Your company manufactures TVs, stereos and speakers, using a common parts inventory of

Chassis =450 units

LCD Screens= 250 units

Speakers= 800 units

Power supplies =450 units

Internal electronics= 600 units in your inventory.

Your company can sell LCD TVs for $75, Stereos for $50, and Speakers for $35. To manufacture

one LCD TV, you need: 1 Chassis, 1 LCD Screen, 2 Speakers, and 1 Power Supply, and 2 Electronics.

one Stereo, you need: 1 Chassis, 2 Speakers, and 1 Power Supply, and 1 Electronics.

one Speaker, you need: 1 Speaker and 1 Electronics.

Questions (not cumulative, questions are always based on the base case of Q1):

Q1: How many TVs, Stereos, and Speakers are you producing?

Q8: You adding a new product, LCD TV Dolby Surround. It has 4 rather than 2 speakers. What is the minimunm price you have to charge for it?

Solutions

Expert Solution


Related Solutions

Can all parts to this be answered using excel? Problem 16-11 (Algorithmic) In preparing for the...
Can all parts to this be answered using excel? Problem 16-11 (Algorithmic) In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougie that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $34 per doll. During the holiday selling season, FTC will sell the dolls for $42 each. If FTC overproduces the dolls, the excess dolls...
Armstrong Corporation manufactures bicycle parts. The company currently has a $19,300 inventory of parts that have...
Armstrong Corporation manufactures bicycle parts. The company currently has a $19,300 inventory of parts that have become obsolete due to changes in design specifications. The parts could be sold for $7,100, or modified for $9,900 and sold for $21,300. 1A) Identify the relevance of the data given in the exercise to the decision about what to do with the obsolete parts (Irrelevant data or Relevant data). Current sales value for unmodified parts Sales value for modified parts Modification costs Current...
Hoo Company sells TVs and it operates a periodic inventory system. On 1 January 2018, the...
Hoo Company sells TVs and it operates a periodic inventory system. On 1 January 2018, the inventory account in firms’ ledger had a balance of 1,200,000. Based on the following information, answer the required questions. 1. Hoo’s accountants conducted a physical counting of inventory on 31 December 2018 and concluded that the value of all the inventories in Hoo’s warehouse was 1,000,000. 2. On 1 May 2018, Hoo purchased more TVs from Kota Inc. at the cost of 600,000. Kota...
1.Pharoah Company sells TVs. The perpetual inventory was stated as $37,200 on the books at December...
1.Pharoah Company sells TVs. The perpetual inventory was stated as $37,200 on the books at December 31, 2020. At the close of the year, a new approach for compiling inventory was used and apparently a satisfactory cut-off for preparation of financial statements was not made. Some events that occurred are as follows. 1. TVs shipped to a customer January 2, 2021, costing $5,000 were included in inventory at December 31, 2020. The sale was recorded in 2021. 2. TVs costing...
Use EXCEL to prepare your solution. Complete the requirements using the class problem as a guide....
Use EXCEL to prepare your solution. Complete the requirements using the class problem as a guide. Be sure to prepare tables and schedules in good form being careful to label all your work. Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow: Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000 552,000 March (budgeted) 19,800 475,200 April (budgeted) 18,950 454,800 May (budgeted) 22,000 528,000 Here is added information about Corning’s operations: All sales are...
Must be completed using Excel. The Bertrand company manufactures radiators for the automotive industry. It sells...
Must be completed using Excel. The Bertrand company manufactures radiators for the automotive industry. It sells its entire annual production of 80,000 units at a price of $ 80 per unit. The company wishes to assess the possibility of modifying its manufacturing process. This modification would reduce direct labor time by 30 minutes, which represents 25% of the time required in Direct Labour per unit. Currently, the time required to make a radiator is 2 hours and the hourly rate...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have interest expense of $2,000,000 and 1,000,000 common shares outstanding, whereas the second would have interest expense of $3,800,000 but only 750,000 shares outstanding. The company is in the 35% tax bracket. Part 1: Construct the...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021. 2020 Sales $600,000 Less Cost of goods sold 320,000 Gross Profit 280,000 Less Operating expenses 190,000 Less Depreciation 30,000 Operating Income (EBIT) 60,000 Less Interest expense 20,000 Earnings Before Taxes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT