Questions
Development cost and timing: $8 million over 2 years Time period 5 years Ramp-up cost: $4...

Development cost and timing: $8 million over 2 years

Time period 5 years

Ramp-up cost: $4 million over 1 year, starting 1st quarter of year 2.

Marketing and support cost: $1.6 million/year, starting 3rd quarter of year 2.

Unit production cost: $550/unit.

Sales and Production volume: 20,000 units/year, starting 3rd quarter of year 2

Discount rate: 3 percent per quarter Unit Price: $1200/unit

1) Using Excel Calculate the NPV for the total period. Calculate the PV for the 1st quarter of the 4th year Calculate the PV for the 2nd quarter of 2nd year What decision (Go or No-Go) will you make for this product based on the NPV? If your development cost were to go up by 25% what is your resulting NPV?

In: Finance

PLEASE SHOW WORKING: find #1 cost sheet, job #2 cost sheet, general journal, t account (ledger)...

PLEASE SHOW WORKING:

find #1 cost sheet, job #2 cost sheet, general journal, t account (ledger) and schedule of COGM, COGS and income. no project base given and asked in the comment

1

Step 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer. This month, you have been asked to develop and manufacture two new tables for customers. You will design and build the tables. This is a no nail, no screw, and no glue manufacturing ( no indirect materials used). You will be keeping track of the costs incurred to manufacture the tables using Job #1 Cost Sheet and Job #2 Cost Sheet.
The cost of the direct materials that can be used to manufacture the table are as follows. These cost are on a per unit basis.
Table Top $2,900.00
Table Leg $1,100.00
Drawer   $490.00
The company uses a job order costing system and applies manufacturing overhead to jobs based on direct labor hours.   
The company estimates that there will be 12 direct labor hours worked during the month.
The estimated manufacturing overhead cost for the month is:
a. Factory supervisor salary per month $4,500.00
b. Rent for the factory per month $1,500.00
c. Depreciation of factory equipment per month $600.00
Total Estimated manufacturing overhead $6,600.00
What is the predetermined manufacturing overhead rate?   Blank 1
Step 2 The first order you received was to manufacture a table using a table top and four legs. This is your Job #1.
Step 3 The customer that has ordered Job #2, wants a table that is the same as Job #1, but wants to also add a drawer to the table.
Step 4 The following is a list of transactions that need to be recorded for the company for activity in the month of December. Record those in the "General Journal" tab of the excel file using the proper format. Please use the following accounts: Accounts Receivables, Raw materials, Work in process, Finished goods, Accumulated depreciation, Accounts payable, Salaries and wages payable, Sales revenue, Manufacturing overhead, Cost of goods sold, Salaries and wages expense, Advertising expenses, and Depreciation expense.
1-Dec Raw Materials purchased on account, $29,000.
5-Dec All Raw Materials needed for Job #1 were requisitioned from the material storage for use during the month. Assume all materials are direct. (After you journalize this entry please enter the information into Job #1 Cost Sheet)
10-Dec The following employee costs were incurred but not paid during the month:
There are three assembly employees that spend 2 hours each, $35 per hour to make the table for Job #1. (After you journalize this entry please enter the information into Job #1 Cost Sheet)
Salary for supervisor of the factory $5,000.
Administrative Salary $2,000.
15-Dec All Raw Materials needed for Job #2 were requisitioned from the material storage for use during the month. Assume all materials are direct. (After you journalize this entry please enter the information into Job #2 Cost Sheet)
16-Dec Rent for the month of December for the factory building incurred but not paid $1,500.
17-Dec Advertising costs incurred but not paid for the month was $1,400.
20-Dec Depreciation for the month of December was recorded on equipment was $750 ($150 for equipment used in the factory and the remainder for equipment used in selling and administrative activities).
22-Dec Manufacturing overhead cost was applied based on direct labor hours to Job #1 based on the POHR determined on the "Job Cost Sheet". (After you journalize this entry please enter the information into Job #1 Cost Sheet)
26-Dec Job #1 was completed and transferred to Finished Goods during the month.
28-Dec The completed table from Job #1 was sold on account to the customer for $34,000 during the month. (Hint: Make sure to account for the cost of the table that was sold using the cost from the job cost sheet.)
31-Dec Direct labor cost incurred but not paid for three employees to start manufacturing Job #2. The employees only worked one hour each, three hours total, $35 per hour during the month and they did not complete their work on the job. (After you journalize this entry please enter the information into Job #2 Cost Sheet)
31-Dec Manufacturing overhead cost was applied based on direct labor hours to Job #2 based on the POHR. Only three direct labor hours were worked on Job #2 during the month. (After you journalize this entry please enter the information into Job #2 Cost Sheet)
31-Dec Any underapplied or overapplied overhead for the month was closed out to Cost of Goods Sold.
Step 5 Post the journal entries that you recorded on the "General Journal" tab to the "T-accounts" tab. This is the company's first month of business, so there will not be any beginning balances. Compute the balance for each T-account after all of the entries have been posted.
Step 6 Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold on the "Schedule of COGM and COGS" tab for Job #1 and Job #2 that were worked on during the month by the company. Make sure to follow the format noted in your book (pg. 87). (Hint: This is the company's first month of operations and therefore the beginning balances will be zero.)
Step 7 Prepare an Income Statement for the month using the Traditional Format on the "Income Statement" tab.  
Step 8 Answer the additional questions below
Check Figure: Cost of Goods Manufactured= $10,810, Net operating income=$17,490
What is the ending balance for raw materials? Blank 2
What is the ending balance for work in process? Blank 3
What is the ending balance for finished goods? Blank 4
What is the actual manufacturing overhead cost incurred during December before adjustment? Blank 5
What is the total applied manufacturing overhead cost during December before adjustment? Blank 6
What is the unadjusted cost of goods sold? Blank 7
Was the manufacturing overhead for the month of December overapplied/underapplied ? Blank 8
What is the amount of Manufacturing overhead overapplied/underapplied? Blank 9
What is the adjusted cost of goods sold? Blank 10
What is gross margin? Blank 11
What is the total prime cost for Job#1? Blank 12
What is the total conversion cost for job #1? Blank 13
What is the total product cost for job#1? Blank 14
What was the period cost incurred for the month of December?   Blank 15
What is the total variable cost incurred for Job #1(assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? Blank 16
What is the contribution margin for Job #1 (assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? Blank 17

What would be the actual (not applied) total fixed manufacturing overhead cost incurred for the company for the month if the order in Job #1 is for five tables instead of one table assuming this cost is with in the relevant range?

In: Accounting

Question 4. Suppose that your firm has higher fixed cost-to-variable cost ratio than comparable firms. Explain...

Question 4.

Suppose that your firm has higher fixed cost-to-variable cost ratio than comparable firms. Explain how EBITDA multiple valuation would be influenced by the difference in this ratio.

In: Accounting

Category Dollars Percent Sales 100% Food Cost $2,375 37% Labor Cost 29% Overhead 24% Profit 10%...

Category Dollars Percent
Sales 100%
Food Cost $2,375 37%
Labor Cost 29%
Overhead 24%
Profit 10%
Category Dollars Percent
Sales 100%
Food Cost 31%
Labor Cost $17,322 34%
Overhead 32%
Profit 3%
Category Dollars Percent
Sales 100%
Food Cost 40%
Labor Cost 29%
Overhead $234 19%
Profit 12%
Category Dollars Percent
Sales $7,700 100%
Food Cost 43%
Labor Cost 32%
Overhead 21%
Profit 4%

Using the figures provided below calculate the missing dollaramounts for each of the Simplified Profit and Loss Statements.

In: Accounting

Financial Break Even Unit Price Unit Variable Cost Fixed Cost Operating Cash Flow Investment Lifeo f...

Financial Break Even Unit Price Unit Variable Cost Fixed Cost Operating Cash Flow Investment Lifeo f Project Discount Rate
h 39 30 32,000 g 320,000 5 11%
j 50 27 55,000 i 440,500 6 15%
l 60 40 100,000 k 520,154 7 3%

In each of the following case, find the unknown variables: be sure to show all work

In: Finance

Variable Fixed Product cost Non manuf. cost Materiales Director X Mano de Obra Directa x Alquiler...

Variable

Fixed

Product cost

Non manuf. cost

Materiales Director

X

Mano de Obra Directa

x

Alquiler Edificio

X

Salarios de Supervisores

X

Comisiones de Venta

X

Utilidades ‘ Fabricas

X

Oficina de Ventas de Alquiler

X

Depresiacion ‘ Fabrica

X

Depresaiacion Equipo de Ventas

X

Publicidad

X

Costo de Facturacion

X

Costo de Envio

X

Trabajador de Linea Salarial

X

In: Accounting

Support-department cost allocations: single-department cost pools; direct, step-down, and reciprocal methods. 1 a. Allocate the total...

Support-department cost allocations: single-department cost pools; direct, step-down, and reciprocal methods.
1 a. Allocate the total Support Department costs to the production departments under the Direct Allocation Method:
Clothing Shoes
Departmental Costs $10,500 $7,500
From:
Information Technology
(5040/9000)*2600 $1,456
(3960/9000)*2600 $1,144
Human Resources
(220/308)*1400 $1,000
(22/308)*1400 $400
Total Departmental Costs $12,956 $9,044
Total Costs to account for: $     22,000
b. Allocate the Support Department Costs to the Production Department under the Step-down (Sequential) Allocation Method IT first sequentially:
To:
IT HR Clothing Shoes
Departmental Costs $2,600 $1,400 $10,500 $7,500
From:
Information Technology -$2,600
(3000/12000)*2600 $650
(5040/12000)*2600 $1,092
(3960/12000)*2600 $858
Human Resources -$2,050
(220/308)*2050 $1,464
(88/308)*2050 $586
Total Departmental Costs $0 $0 $13,056 $8,944
Total Costs to account for: $     22,000
c. Allocate the Support Department Costs to the Production Department under the Step-down (Sequential) Allocation Method HR first sequentially:
To:
HR IT Clothing Shoes
Departmental Costs $1,400 $2,600 $10,500 $7,500
From:
Human Resources -$1,400
(92/400) _ $1,400 $322
(220/400) _ $1,400 $770
(88/400) _ $1,400 $308
Information Technology -$2,922
(5,040/9,000) _ $2,922 $1,636
(3,960/9,000) _ $2,922 $1,286
Total Departmental Costs $0 $0 $12,906 $9,094
Total Costs to account for: $     22,000
d. Allocate the Support Department Costs to the Production Department under the Reciprocal Allocation Method:
i. Assign reciprocal equations to the support departments
IT=(2600+92 employees/400 employees*HR)
IT   = $2,600+0.23HR
HR = ($1,400+.025 IT)
HR=($1,400+3,000 hours/1,200 hours IT)
ii. Solve the equation to complete the reciprocal costs of the support departments
IT=$2,600+.023($1,400+0.25 IT)
IT= $2,600+$322+0.0575IT
0.9425 IT = $2,922
      IT = $       3,100
HR= $1,400+0.25 IT
HR= $1,400+0.25(3,100)
HR= $1,400+775
HR = $2,175
iii. Allocate Reciprocal costs to departments (all numbers rounded to nearest dollar)
IT HR Clothing Shoes
Departmental Costs $2,600 $1,400 $10,500 $7,500
Information Technology -$3,100
(3000/12000)*$3,100 $775
(5040/12000)*$3,100 $1,302
(3960/12000)*$3,100 $1,023
Human Resources -$2,175
(92/400)*$2,175 $500
(220/400)*$2,175 $1,196
(88/400)*$2,175 $479
Total Departmental Costs $0 $0 $12,998 $9,002
$     22,000
Reciprocal Method of Allocating Support Department Costs for Sportz, Inc. Using Repeated Iterations.
Support Departments Operating Departments
IT HR Clothing Shoes
Budgeted manufacturing overhead costs before any interdepartmental cost allocations
1st Allocation of IT Dept.
(0.25, 0.42, 0.33)b
1st Allocation of HR Dept.
2nd Allocation of IT Dept.
2nd Allocation of HR Dept.
3rd Allocation of IT Dept.
3rd Allocation of HR Dept.
4th Allocation of IT Dept.
Total budgeted manufacturing
overhead of operating departments

I understand the first half just not the both half.

Sportz, Inc., manufactures athletic shoes and athletic clothing for both amateur and professional athletes. The company has two product lines (clothing and shoes), which are produced in separate manufacturing facilities; however, both manufacturing facilities share the same support services for information technology and human resources. The following shows total costs for each manufacturing facility and for each support department.

Variable Costs Fixed Costs Total Costs by Department
Information Technology 600 2,000 2,600
Human Resources 400 1,000 1,400
Clothing 2,500 8,000 10,500
Shoes 3,000 4,500 7,500
Total Costs 6,500 15,500 22,000

The total costs of the support departments (IT and HR) are allocated to the production departments (clothing and shoes) using a single rate based on the following:

Information technology: Number of IT labor-hours worked by department
Human resources: Number of employees supported by department

Data on the bases, by department, are given as follows:

Department

IT Hours Used

Number of Employees

Clothing

5,040

220

Shoes

3,960

88

Information technology

-

92

Human resources

3,000

-

What are the total costs of the production departments (clothing and shoes) after the support department costs of information technology and human resources have been allocated using (a) the direct method, (b) the step-down method (allocate information technology first), (c) the step-down method (allocate human resources first), and (d) the reciprocal method?

Assume that all of the work of the IT department could be outsourced to an independent company for $97.50 per hour. If Sportz no longer operated its own IT department, 30% of the fixed costs of the IT department could be eliminated. Should Sportz outsource its IT services?

In: Accounting

Units Per unit cost Total cost 5,000 units 5000 17.00 85000 7,500 units 7500 13.00 97500...

Units Per unit cost Total cost
5,000 units 5000 17.00 85000
7,500 units 7500 13.00 97500
Difference 2500 12500
Unit variable cost 5 =12500/2500
Fixed cost 60000 =85000-(5000*5)
Y = $60,000 + $5X

what is that X suppose to mean ?is the answer 60,005?

In: Accounting

Turbine United Hydro Services Kiser Hydro, LLC Initial Cost $200,000 $1,500,000 Maintenance Cost $200 per year,...

Turbine United Hydro Services Kiser Hydro, LLC
Initial Cost $200,000 $1,500,000
Maintenance Cost $200 per year, increasing by 4% per year $1,000 per year for the first ten years, then $2,000 per year thereafter
Overhaul Cost $50,000 at year ten $750,000 at year thirty
Income $20,000 per year $25,000 per year
Salvage Value $15,000 $50,000
Life 20 Years Infinite

. Memphis Light, Gas and Water Division is exploring the possibility of installing hydrokinetic turbines in the Mississippi River to generate power for the Memphis and Shelby County area. Consulting engineers have identified two potential types of hydrokinetic turbines to meet the needs of MLG&W. The costs and expected income for the two types of turbines are shown in the table below. Using a perpetual annual worth analysis and a MARR of 6% per year, determine which type of hydrokinetic turbine, if any, should be selected. Complete all calculations to the nearest dollar.

In: Economics

Data Manufactured in-house Fixed cost $50,000 Unit variable cost $125 Payoff Table Demand Purchased from supplier...

Data
Manufactured in-house
Fixed cost $50,000
Unit variable cost $125 Payoff Table
Demand
Purchased from supplier             800       1,000       1,200       1,400
Unit cost $175 Manufacture $150,000 $175,000 $200,000 $225,000
Outsource $140,000 $175,000 $210,000 $245,000
Production volume 1500
Model ANSWER Manufacture/Outsource Value
Average Payoff
Total manufacturing cost $237,500 Aggressive
Total purchased cost $262,500 Conservative
Cost difference (Manufacture - Purchase) -$25,000
Best Decision Manufacture

Problem 16A Payoff Tables

Based on the cost model and payoff table provided, determine the average payoff strategy, aggressive, and conservative recommendation. Remember that this payoff table is based on cost so you will want to recommend decisions under each strategy which minimize cost.

Enter your answer in the table by stating whether manufacturing or outsources would be the best choice for each strategy and the value associated with that option.

In: Accounting