Question

In: Accounting

EKPN Company prepared the following data in its static budget based on 150,000 machine hours: Direct...

EKPN Company prepared the following data in its static budget based on 150,000 machine hours: Direct Materials $ 450,000 Direct Labour 225,000 Variable Overhead 1,125,000 Fixed Overhead 2,100,000

Actual Results: Machine Hours 160,000 hours Direct Materials $475,000 Direct Labour 245,000 Variable Overhead 1,150,000 Fixed Overhead 2,110,000


(i). What was the budgeted variable costs per machine hour for variable overhead, rounded to the nearest whole cent? a) $7.03/machine hour b) $7.50/machine hour c) $19.53/machine hour d) $20.83/machine hour


(ii). What is the budgeted Direct Labour cost at the actual level of activity? a) $245,000 b) $240,000 c) $210,938 d) $20,000


(iii). What is the budgeted Fixed Overhead at the actual level of activity? a) $2,100,000 b) $2,110,000 c) $2,240,000 d) $3,260,000


(iv). What was the difference between the actual and budgeted Direct Material costs at the actual level of activity? a) $25,000 unfavourable b) $25,000 favourable c) $5,000 unfavourable d) $5,000 favourable


(v). What possible reason could explain the difference between the actual fixed overhead costs and the budgeted fixed overhead costs? a) EKPN Company’s actual machine hours were greater than the budgeted amount. b) EKPN Company’s actual machine hours were less than the budgeted amount. c) EKPN Company spent more on fixed costs than it expected. d) EKPN Company spent less on fixed costs than expected.


Q#2: 20 Marks

Nick’s Novelties, Inc. is considering the purchase of electronic pinball machines to place in game arcades. The machines would cost a total of $300,000, have an eight-year useful life, and have a total salvage value of $20,000. The company estimated that annual revenues and expenses associated with the machines would be as follows:

Revenues $200,000 Operating expenses: Commissions to game arcades $100,000 Insurance 7,000 Depreciation 35,000 Maintenance 18,000 160,000 Net operating income $ 40,000 Required: 1. Assume that Nick’s Novelties, Inc. will not purchase new equipment unless it provides a payback period of five years of less. Will the company purchase the pinball machines?

2. If Nick’s Novelties, Inc. has a discount rate of 18%, what is the NPV of this investment?






















EKPN Company prepared the following data in its static budget based on 150,000 machine hours: Direct Materials $ 450,000 Direct Labour 225,000 Variable Overhead 1,125,000 Fixed Overhead 2,100,000

Actual Results: Machine Hours 160,000 hours Direct Materials $475,000 Direct Labour 245,000 Variable Overhead 1,150,000 Fixed Overhead 2,110,000


(i). What was the budgeted variable costs per machine hour for variable overhead, rounded to the nearest whole cent? a) $7.03/machine hour b) $7.50/machine hour c) $19.53/machine hour d) $20.83/machine hour


(ii). What is the budgeted Direct Labour cost at the actual level of activity? a) $245,000 b) $240,000 c) $210,938 d) $20,000


(iii). What is the budgeted Fixed Overhead at the actual level of activity? a) $2,100,000 b) $2,110,000 c) $2,240,000 d) $3,260,000


(iv). What was the difference between the actual and budgeted Direct Material costs at the actual level of activity? a) $25,000 unfavourable b) $25,000 favourable c) $5,000 unfavourable d) $5,000 favourable


(v). What possible reason could explain the difference between the actual fixed overhead costs and the budgeted fixed overhead costs? a) EKPN Company’s actual machine hours were greater than the budgeted amount. b) EKPN Company’s actual machine hours were less than the budgeted amount. c) EKPN Company spent more on fixed costs than it expected. d) EKPN Company spent less on fixed costs than expected.


Q#2: 20 Marks

Nick’s Novelties, Inc. is considering the purchase of electronic pinball machines to place in game arcades. The machines would cost a total of $300,000, have an eight-year useful life, and have a total salvage value of $20,000. The company estimated that annual revenues and expenses associated with the machines would be as follows:

Revenues $200,000 Operating expenses: Commissions to game arcades $100,000 Insurance 7,000 Depreciation 35,000 Maintenance 18,000 160,000 Net operating income $ 40,000 Required: 1. Assume that Nick’s Novelties, Inc. will not purchase new equipment unless it provides a payback period of five years of less. Will the company purchase the pinball machines?

2. If Nick’s Novelties, Inc. has a discount rate of 18%, what is the NPV of this investment?






















Solutions

Expert Solution

Answer 1 :

Part i)

Budgeted variable cost for variable overhead = 1125000 / 150000 = $7.50 per machine hour

Option b is correct

Part ii)

Budgeted direct labor rate = 225000 / 150000 = $1.5 per hour

Budgeted direct labor cost at actual activity = 1.5 * 160000 = $240000

Option b is correct

Part iii)

Budgeted fixed cost = 2,100,000

Because it is fixed

Option a is correct

Part iv)

Budgeted direct material cost at actual activity = [450000 / 150000 ] * 160000 = 480000

Difference = 4750000 - 480000 = $5000 favorable

Option d is correct

Part v)

Option c is correct

Because it spent more on fixed expenses.

Answer: 2

Part 1

Yes, the pinball machines would be purchased. The payback period is less than the maximum 5 years required by the company.

Payback period

=

Investment required

Annual cash inflow

Payback period

=

$300,000

=

4

Years

$75,000

Cash flow = Net income + depreciation = 40000 + 35000 = 75000


Related Solutions

Company uses standard costing. The company prepared its static budget for 2018 at 2,500,000 machine hours...
Company uses standard costing. The company prepared its static budget for 2018 at 2,500,000 machine hours for the year. Total budgeted overhead cost is $33,500,000. The variable overhead rate is $11 per machine hour ($22 per unit). Actual result for 2018 as follow: Machine-hours 2,400,000 hours Output 1,230,000 units Variable overhead $27,600,000 Fixed overhead rate variance $1,350,000 U 1. Calculate for the fixed​ overhead: a. Budgeted amount. b. Budgeted cost per​ machine-hour. c. Actual cost. d. ​Production-volume variance. 2. Calculate...
A static overhead budget based on 40,000 direct labor hours shows Factory Insurance $6,500 as a...
A static overhead budget based on 40,000 direct labor hours shows Factory Insurance $6,500 as a fixed cost. At the 50,000 direct labor hours worked in March, factory insurance costs were $6,300. Is this a favorable or unfavorable performance? Why?
A static overhead budget based on 40,000 direct labor hours shows Factory Insurance $6,500 as a...
A static overhead budget based on 40,000 direct labor hours shows Factory Insurance $6,500 as a fi xed cost. At the 50,000 direct labor hours worked in March, factory insurance costs were $6,300. Is this a favorable or unfavorable performance? Why?
Reflector Glass Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6 comma...
Reflector Glass Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6 comma 0006,000 Per Unit Sales Revenue $ 5.00$5.00 $ 30 comma 000$30,000 Variable Costs 1.501.50 9 comma 0009,000 Contribution Margin 21 comma 00021,000 Fixed Costs 4 comma 0004,000 Operating​ Income/(Loss) $ 17 comma 000$17,000 If a flexible budget is prepared at a volume of 8 comma 9008,900 ​units, calculate the amount of operating income. The production level is within the relevant range. A. $ 4...
Speedy Bikes Couriers Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6...
Speedy Bikes Couriers Company prepared the following static budget for the​ year: Static Budget ​Units/Volume 6 comma 000 Per Unit Sales Revenue $ 5 $ 30 comma 000 Variable Costs 1 6 comma 000 Contribution Margin 24 comma 000 Fixed Costs 4 comma 000 Operating​ Income/(Loss) $ 20 comma 000 If a flexible budget is prepared at a volume of 7 comma 500​, calculate the amount of operating income. The production level is within the relevant range. A. $ 20...
Wytch Corporation bases its budgets on machine-hours. The company's static planning budget for February appears below:...
Wytch Corporation bases its budgets on machine-hours. The company's static planning budget for February appears below: Budgeted number of machine-hours 6,000 Budgeted variable costs:    Supplies (@ $6.90 per machine-hour) $ 41,400    Power (@ $3.70 per machine-hour) 22,200 Budgeted fixed costs:    Salaries 51,600    Equipment depreciation 26,400 Total expense $ 141,600 Required: Prepare a flexible budget for 6,400 machine-hours per month.
Pulham Company is preparing its direct labor budget for 2016 from the following production budget based...
Pulham Company is preparing its direct labor budget for 2016 from the following production budget based on a calendar year:  Each unit requires 2 hours of direct labor. The union contract provides for a 10% increase in wage rate to $11 per hour on October 1.  Prepare a direct labor budget for 2016. 
A static budget, based upon production of 10,000 units, showed an estimated direct labor budget of...
A static budget, based upon production of 10,000 units, showed an estimated direct labor budget of $30,000 and depreciation budget of $20,000. Direct labor costs are fully variable. The actual direct labor and depreciation costs were $28,000 and $19,000 for 8,000 units. Which total amount should be shown in the flexible budget for direct labor and depreciation costs?
Birdstock establishes a static budget at the beginning of each year. Birdstock uses machine hours to...
Birdstock establishes a static budget at the beginning of each year. Birdstock uses machine hours to allocate fixed overhead. Based on the static budget, the budgeted fixed overhead for the year totaled $1,644,000 and the budgeted machine hours totaled 411,000. For May, the actual fixed overhead was $150,000 and the actual machine hours were 15,000. What is the rate that Birdstock will use to apply overhead in May? Select one: a. $109.60 per machine hour b. $4.00 per machine hour...
Lansing Mfg. prepared the following annual abbreviated flexible budget for different levels of machine hours: 40,000...
Lansing Mfg. prepared the following annual abbreviated flexible budget for different levels of machine hours: 40,000 44,000 48,000 52,000 Variable manufacturing overhead $80,000 $88,000 $96,000 $104,000 Fixed manufacturing overhead 325,000 325,000 325,000 325,000 Each product requires four hours of machine time and the company expects to produce 10,000 units for the year. Assume that Lansing Mfg. has decided to use units of production to apply overhead to production. In April of the current year, the company produced 900 units and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT