Homework Answers
Answer:
| 1 | B | C | D | E | F | G | H | I | J | K | L | M |
| 2 | Year | Item | Number of Units | Rate | Hours | Cash Outflow | Total Cash Outflow for Each Year | Present Value of the Cash Outflow for Each Year | Cash Inflow | Total Cash Inflow for Each Year | Present Value of the total Cash Inflow for each Year | Profit for Each = Total Cash Inflow - Total Cash Outflow for Each Year |
| 3 | Year 1 | Engineering Time | 125 | 500 | 62500 | 62500 | 54945.05495 | 0 | 0 | 0 | -62500 | |
| 4 | Production Time | 75 | 0 | NA | ||||||||
| 5 | Unit Sales | 0 | NA | |||||||||
| 6 | Year2 | Engineering Time | 125 | 10 | 1250 | 24800 | 19166.7673 | 375000 | 289820.07 | 350200 | ||
| 7 | Production Time | 75 | 200 | 15000 | ||||||||
| 8 | Q & A Testing | 90 | 95 | 8550 | ||||||||
| 9 | Equipment Unit Sales | 500000 | 0.75 | 375000 | ||||||||
| 10 | Year 3 | Engineering Time | 100 | 100 | 10000 | 225000 | 152872.1249 | 750000 | 509573.7495 | 525000 | ||
| 11 | Manufacturing Time | 75 | 2200 | 165000 | ||||||||
| 12 | Manufacturing Equipments | |||||||||||
| 13 | Manufacturing Materials | 1000000 | 0.05 | 50000 | ||||||||
| 14 | Equipment Unit Sales | 1000000 | 0.75 | 750000 | ||||||||
| 15 | Year 4 | Manufacturing | 75 | 2200 | 165000 | 215000 | 128420.0512 | 750000 | 447976.9227 | 535000 | ||
| 16 | Manufacturing Materials | 1000000 | 0.05 | 50000 | ||||||||
| 17 | Unit Sales | 1000000 | 0.75 | 750000 | ||||||||
| 18 | Year 5 | Manufacturing | 75 | 2200 | 165000 | 215000 | 112896.7483 | 750000 | 393825.8661 | 535000 | ||
| 19 | Manufacturing Materials | 1000000 | 0.05 | 50000 | ||||||||
| 20 | Unit Sales | 1000000 | 0.75 | 750000 | ||||||||
| 21 | Total | 468300.7465 | Total | 1641196.608 | ||||||||
| 22 | Net Present Value or NPV at Year Five | 1172895.862 | ||||||||||
Formula
| 1 | B | C | D | E | F | G | H | I | J | K | L | M |
| 2 | Year | Item | Number of Units | Rate | Hours | Cash Outflow | Total Cash Outflow for Each Year | Present Value of the Cash Outflow for Each Year | Cash Inflow | Total Cash Inflow for Each Year | Present Value of the total Cash Inflow for each Year | Profit for Each = Total Cash Inflow - Total Cash Outflow for Each Year |
| 3 | Year 1 | Engineering Time | 125 | 500 | =E3*F3 | =G3 | =H3/(1+0.1375) | 0 | 0 | 0 | =K3-H3 | |
| 4 | Production Time | 75 | 0 | NA | ||||||||
| 5 | Unit Sales | 0 | NA | |||||||||
| 6 | Year 2 | Engineering Time | 125 | 10 | =E6*F6 | =SUM(G6:G8) | =H6/((1+0.1375)^2) | =J9 | =K6/((1+0.1375)^2) | =K6-H6 | ||
| 7 | Production Time | 75 | 200 | =E7*F7 | ||||||||
| 8 | Q & A Testing | 90 | 95 | =E8*F8 | ||||||||
| 9 | Equipment Unit Sales | 500000 | 0.75 | =D9*E9 | ||||||||
| 10 | Year 3 | Engineering Time | 100 | 100 | =E10*F10 | =SUM(G10:G13) | =H10/((1+0.1375)^3) | =J14 | =K10/((1+0.1375)^3) | =K10-H10 | ||
| 11 | Manufacturing Time | 75 | 2200 | =E11*F11 | ||||||||
| 12 | Manufacturing Equipments | |||||||||||
| 13 | Manufacturing Materials | 1000000 | 0.05 | =D13*F13 | ||||||||
| 14 | Equipment Unit Sales | 1000000 | 0.75 | =D14*E14 | ||||||||
| 15 | Year 4 | Manufacturing | 75 | 2200 | =E15*F15 | =SUM(G15:G16) | =H15/((1+0.1375)^4) | =J17 | =K15/((1+0.1375)^4) | =K15-H15 | ||
| 16 | Manufacturing Materials | 1000000 | 0.05 | =D16*F16 | ||||||||
| 17 | Unit Sales | 1000000 | 0.75 | =D17*E17 | ||||||||
| 18 | Year 5 | Manufacturing | 75 | 2200 | =E18*F18 | =SUM(G18:G19) | =H18/((1+0.1375)^5) | =J20 | =K18/((1+0.1375)^5) | =K18-H18 | ||
| 19 | Manufacturing Materials | 1000000 | 0.05 | =D19*F19 | ||||||||
| 20 | Unit Sales | 1000000 | 0.75 | =D20*E20 | ||||||||
| 21 | Total | =SUM(I3:I20) | Total | =SUM(L3:L20) | ||||||||
| 22 | Net Present Value or NPV at Year Five | =L21-I21 | ||||||||||
Add Answer to:
I) You are proposing a new plastic product. The material and energy costs for cach part...
Activity-Based Product Costing Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta,...
Activity-Based Product Costing Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Activity Cost Pool Production $259,200 Setup 55,000 Materials handling 9,750 Inspection 60,000 Product engineering 123,200 Total $507,150 The activity bases identified for each activity are as...
Styles The new president of the Wemecke Company was stumped. Why had profits gone down? He had directed the sales department to push the product with the highest contribution margin, and the s...
Styles The new president of the Wemecke Company was stumped. Why had profits gone down? He had directed the sales department to push the product with the highest contribution margin, and the sales department had come through with flying colors. The percent of flams sold had increased from 25% of units sold to 37.5% of units sold. So what happened? ams Sales Price per Unit Direct Materials per Unit $150 $75 $500 $200 $25 Direct Labor Cost per Hour $25...
You have been hired as new analyst at Foxconn Interconnect Technology Limited (FIT) and have been...
You have been hired as new analyst at Foxconn Interconnect Technology Limited (FIT) and have been asked to evaluate the new manufacturing plant to produce new state of art internet security system. Suppose that FIT is considering expanding its wireless home networking appliance, called EasyNet, that will provide both the hardware and the software necessary to run an entire home from any Internet connection. EasyNet will also control new Internet-capable stereos, digital video recorders, heating and air-conditioning units, major appliances,...
Calculate Lead Time Flint Fabricators Inc. machines metal parts for the automotive industry. Under the traditional...
Calculate Lead Time Flint Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and finishing Parts are produced in batch sizes of 65 parts. A part requires 5 minutes in milling and 8 minutes in finishing. The move time between the two operations for a complete batch is 9 minutes Under the lean philosophy, the part is produced in a cell that includes both the milling and...
i just need part B please and thank you Exercise 7-24 (Algo) Assigning Costs to Jobs...
i just need part B please and thank you
Exercise 7-24 (Algo) Assigning Costs to Jobs (LO 7-1, 2) Forest Components makes aircraft parts. The following transactions occurred in July 2.5 points 1 Purchased $16,960 of materials on account 2. Issued $16,750 in direct materials to the production department 3. Issued $1,330 of supplies from the materials Inventory 4. Pald for the materials purchased in transaction (1) using cash. 5. Returned $2,130 of the materials issued to production in (2)...
Morganton Company makes one product and it provided the following information to help prepare the master...
Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,200, 12,000, 14,000, and 15,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...
Part A Part B Problem 10.34A a-e Greish Inc. is preparing its annual budgets for the...
Part A
Part B
Problem 10.34A a-e Greish Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants have provided the following data: Product LN 35 Product LN 40 Sales budget Expected volume in units 402,000 241,000 Unit selling price $31 $35 Production budget Desired ending finished good units 31,000 21,000 Beginning finished goods units 21,000 16,000 Direct materials budget: Direct materials per unit (kilograms) 2 3 Desired kilograms of ending direct materials 47,000 15,000...
Cartwright Inc produces wiring harnesses used in semi-trailers. The wiring harnesses sales for the next 4 months is proj...
Cartwright Inc produces wiring harnesses used in semi-trailers.
The wiring harnesses sales for the next 4 months is projected to
be:
January 15,000. February 17,000,
March 22,000, April 24,000, May 26,000.
Finished goods inventory on January 1 is expected to be 5000
units. The desired ending FGI for any month (except for the Dec 31
inventory as noted previously) is expected to be 20% of the
following month’s sales.
Data for materials used are: Part A87 4 parts per
unit ...
This question has multiple parts: Part 1. Martin Clothing Company is a retail company that sells...
This question has multiple parts: Part 1. Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 95,000 $ 69,000 $ 21,000 June 115,000 90,000 28,500 July 131,000 111,000 33,000 August 130,000...
I just need the bottom part but wanted to give you everything I had already done...
I just need the bottom part but wanted to give you everything I
had already done incase that helped, thank you
Several years after reengineering its production process, Zeke Corporation hired a new controller, Barb Joe. (Click the icon to view additional information.) For the upcoming year, Zeke's budgeted ABC manufacturing overhead allocation rates are as follows: (Click the icon to view the additional data.) Requirement 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Enter the...
Styles The new president of the Wemecke Company was stumped. Why had profits gone down? He had directed the sales department to push the product with the highest contribution margin, and the sales department had come through with flying colors. The percent of flams sold had increased from 25% of units sold to 37.5% of units sold. So what happened? ams Sales Price per Unit Direct Materials per Unit $150 $75 $500 $200 $25 Direct Labor Cost per Hour $25...
Calculate Lead Time Flint Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and finishing Parts are produced in batch sizes of 65 parts. A part requires 5 minutes in milling and 8 minutes in finishing. The move time between the two operations for a complete batch is 9 minutes Under the lean philosophy, the part is produced in a cell that includes both the milling and...
i just need part B please and thank you
Exercise 7-24 (Algo) Assigning Costs to Jobs (LO 7-1, 2) Forest Components makes aircraft parts. The following transactions occurred in July 2.5 points 1 Purchased $16,960 of materials on account 2. Issued $16,750 in direct materials to the production department 3. Issued $1,330 of supplies from the materials Inventory 4. Pald for the materials purchased in transaction (1) using cash. 5. Returned $2,130 of the materials issued to production in (2)...
Part A
Part B
Problem 10.34A a-e Greish Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants have provided the following data: Product LN 35 Product LN 40 Sales budget Expected volume in units 402,000 241,000 Unit selling price $31 $35 Production budget Desired ending finished good units 31,000 21,000 Beginning finished goods units 21,000 16,000 Direct materials budget: Direct materials per unit (kilograms) 2 3 Desired kilograms of ending direct materials 47,000 15,000...
Cartwright Inc produces wiring harnesses used in semi-trailers.
The wiring harnesses sales for the next 4 months is projected to
be:
January 15,000. February 17,000,
March 22,000, April 24,000, May 26,000.
Finished goods inventory on January 1 is expected to be 5000
units. The desired ending FGI for any month (except for the Dec 31
inventory as noted previously) is expected to be 20% of the
following month’s sales.
Data for materials used are: Part A87 4 parts per
unit ...
I just need the bottom part but wanted to give you everything I
had already done incase that helped, thank you
Several years after reengineering its production process, Zeke Corporation hired a new controller, Barb Joe. (Click the icon to view additional information.) For the upcoming year, Zeke's budgeted ABC manufacturing overhead allocation rates are as follows: (Click the icon to view the additional data.) Requirement 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Enter the...
Most questions answered within 3 hours.
-
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 41 minutes ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 43 minutes ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 48 minutes ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 52 minutes ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 1 hour ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 1 hour ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 1 hour ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 1 hour ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 1 hour ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 1 hour ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 1 hour ago -
Inheritance pattern in BRCA 1
Describe the inheritance pattern of BRCA 1 Is it recessive or...
asked 1 hour ago