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
Rahul Sunny answered 1 year agoRelated 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
Latest Questions
- K-NN and Perceptron theory question If we don’t care about the size of the TRAINING SET...
- Make a C program that simulates time-sharing in the operating system. Please follow the instructions provided:...
- What are some current challenges faced by food companies in reducing food waste?
- Arthur buys $2,200.00 worth of stock. Six months later, the value of the stock has risen...
- The Following table is based on a time study for a metal working operation Obs (minutes...
- Write a method that returns the percentage of the number of elements that have the value true...
- Jane is the financial manager for Alpha Corporation. She has been asked to perform a lease-versus-purchase...
ADVERTISEMENT