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 |
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, 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 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 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 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)...
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 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 ...
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 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...