Question

In: Accounting

PA4-4 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6] Keller...

PA4-4 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6] Keller Company makes two models of battery-operated boats, the Sandy Beach and the Rocky River. Basic production information follows: Sandy Beach Rocky River Direct materials cost per unit $ 19.70 $ 27.80 Direct labor cost per unit 13.10 18.80 Sales price per unit 83.20 106.00 Expected production per month 1,210 units 980 units Keller has monthly overhead of $11,272, which is divided into the following cost pools: Setup costs $ 2,170 Quality control 5,940 Maintenance 3,162 Total $ 11,272 The company has also compiled the following information about the chosen cost drivers: Sandy Beach Rocky River Total Number of setups 15 20 35 Number of inspections 120 375 495 Number of machine hours 1,550 1,550 3,100 Required: 1. Suppose Keller uses a traditional costing system with machine hours as the cost driver. Determine the amount of overhead assigned to each product line. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount.) 2. Calculate the production cost per unit for each of Keller’s products under a traditional costing system. (Round your intermediate calculations and final answers to 2 decimal places.) 3. Calculate Keller’s gross margin per unit for each product under the traditional costing system. (Round your intermediate calculations and final answers to 2 decimal places.) 4. Select the appropriate cost driver for each cost pool and calculate the activity rates if Keller wanted to implement an ABC system. (Round your answers to 2 decimal places.) 5. Assuming an ABC system, assign overhead costs to each product based on activity demands.(Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.) 6. Calculate the production cost per unit for each of Keller’s products with an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.) 7. Calculate Keller’s gross margin per unit for each product under an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.) 8. Compare the gross margin per unit of each product under the traditional system and ABC. (Round your answers to 2 decimal places.

Solutions

Expert Solution

1 Overhead rate=Total overhead cost/Total number of machine hours=11272/3100=$ 3.636129 per machine hour
Overhead cost assigned:
Sandy Beach Rocky River
Overhead rate a 3.636129 3.636129
Number of machine hours b 1550 1550
Overhead cost assigned a*b 5636 5636
2 Production cost per unit:
Sandy Beach Rocky River
Direct materials cost 19.7 27.8
Direct labor cost 13.1 18.8
Overhead cost per unit (Note:1) 4.66 5.75
Total 37.46 52.35
Note:1
Overhead cost per unit:
Sandy Beach Rocky River
Overhead cost assigned a 5636 5636
Expected production b 1210 980
Overhead cost per unit 4.66 5.75
3 Gross margin per unit:
Sandy Beach Rocky River
Sales price per unit 83.2 106
Less: Production cost per unit 37.46 52.35
Gross margin per unit 45.74 53.65
4 Activity Overhead cost Cost driver $ Activity rate
a b a/b
Setup costs 2170 No.of setups 35 62 Per setup
Quality control 5940 No.of inspections 495 12 Per inspection
Maintenance 3162 No.of machine hours 3100 1.02 Per MH
11272
5 Overhead assigned
Sandy beach Rocky river
Activity Activity rate Cost driver usage Overhead assigned Cost driver usage Overhead assigned
a b c=a*b d e=a*d
Setup costs 62 Per setup 15 930 20 1240
Quality control 12 Per inspection 120 1440 375 4500
Maintenance 1.02 Per MH 1550 1581 1550 1581
Total 3951 7321
6 Production cost per unit:
Sandy Beach Rocky River
Direct materials cost 19.7 27.8
Direct labor cost 13.1 18.8
Overhead cost per unit (Note:2) 3.27 7.47
Total 36.07 54.07


Related Solutions

PA4-3 Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour...
PA4-3 Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows:     Home Work Direct materials cost per unit $ 39 $ 64 Direct labor cost per unit 23 33 Sales price per unit 351 572 Expected production per month 600 units 490 units      Harbour has monthly overhead of $213,390, which is divided into the following cost pools:...
Required information PA4-4 Identifying and Preparing Adjusting Journal Entries [LO 4-1, LO 4-2, LO 4-3, LO...
Required information PA4-4 Identifying and Preparing Adjusting Journal Entries [LO 4-1, LO 4-2, LO 4-3, LO 4-6] [The following information applies to the questions displayed below.] Val’s Hair Emporium operates a hair salon. Its unadjusted trial balance as of December 31, 2018, follows, along with information about selected accounts. Account Names Debit Credit Further Information Cash $ 2,800 As reported on December 31 bank statement. Supplies 3,300 Based on count, only $800 of supplies still exist. Prepaid Rent 3,000 This...
1.  Explain the role of activity drivers in assigning costs to products. 2. Why are the accounting...
1.  Explain the role of activity drivers in assigning costs to products. 2. Why are the accounting requirements for job order costing more demanding than those of process costing? 3. Folio Glass produces custom glass platters. For one job, the trainee assigned to cut the glass set the template incorrectly into the computer. This template was unusable and had to be discarded; another template was cut to the correct dimensions. How is the cost of the spoiled template handled?
Exercise 4-6 Assigning overhead costs using the plantwide rate and departmental rate methods LO P1, P2...
Exercise 4-6 Assigning overhead costs using the plantwide rate and departmental rate methods LO P1, P2 Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk lamp. This lamp is made from components shaped in the fabricating department and assembled in the assembly department. Information related to the 33,000 desk lamps produced annually follows. Direct materials $ 270,000 Direct labor Fabricating department (6,000 DLH × $28 per DLH) $ 168,000 Assembly department (16,000 DLH...
Problem 10-69 (Algo) Assigning Capacity Costs: Seasonality (LO 10-6) Mercia Chocolates produces gourmet chocolate products with...
Problem 10-69 (Algo) Assigning Capacity Costs: Seasonality (LO 10-6) Mercia Chocolates produces gourmet chocolate products with no preservatives. Any production must be sold within a few days, so producing for inventory is not an option. Mercia’s single plant has the capacity to make 91,500 packages of chocolate annually. Currently, Mercia sells to only two customers: Vern’s Chocolates (a specialty candy store chain) and Mega Stores (a chain of department stores). Vern’s orders 48,300 packages and Mega Stores orders 16,500 packages...
PA4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO 4-5]...
PA4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO 4-5] Required: 1-a. Prepare an adjusted trial balance at September 30, 2015. Starbooks Corporation provides an online bookstore for electronic books. The following is a simplified list of accounts and amounts reported in its accounting records. The accounts have normal debit or credit balances. Assume the year ended on September 30, 2015. PA4-1 Part 2 2. Prepare the closing entry required at September 30, 2015....
    E2-6 (Algo) Finding Unknown Values in the Cost of Goods Manufactured Report [LO 2-3, 2-6]...
    E2-6 (Algo) Finding Unknown Values in the Cost of Goods Manufactured Report [LO 2-3, 2-6] Mulligan Manufacturing Company uses a job order cost system with overhead applied to products at a rate of 150 percent of direct labor cost. Required: Treating each case independently, selected from the manufacturing data given below, find the missing amounts. You should do them in the order listed. (Hint: For the manufacturing costs in Case 3, first solve for conversion costs and then determine...
PA4-2 Analyzing and Recording Adjusting Journal Entries [LO 4-1, LO 4-2] Brokeback Towing Company is at...
PA4-2 Analyzing and Recording Adjusting Journal Entries [LO 4-1, LO 4-2] Brokeback Towing Company is at the end of its accounting year, December 31, 2015. The following data that must be considered were developed from the company’s records and related documents: a. On July 1, 2015, a two-year insurance premium on equipment in the amount of $672 was paid and debited in full to Prepaid Insurance on that date. Coverage began on July 1. b. At the end of 2015,...
Posting again because the first response was wrong. Problem 10-69 (Algo) Assigning Capacity Costs: Seasonality (LO...
Posting again because the first response was wrong. Problem 10-69 (Algo) Assigning Capacity Costs: Seasonality (LO 10-6) Mercia Chocolates produces gourmet chocolate products with no preservatives. Any production must be sold within a few days, so producing for inventory is not an option. Mercia’s single plant has the capacity to make 91,500 packages of chocolate annually. Currently, Mercia sells to only two customers: Vern’s Chocolates (a specialty candy store chain) and Mega Stores (a chain of department stores). Vern’s orders...
E2-10 (Algo) Preparing Cost of Goods Manufactured and Income Statement [LO 2-6] Manufacturing costs for Davenport...
E2-10 (Algo) Preparing Cost of Goods Manufactured and Income Statement [LO 2-6] Manufacturing costs for Davenport Company during 2018 were as follows: Beginning Finished Goods, 1/1/18 $ 26,100 Beginning Raw Materials, 1/1/18 37,500 Beginning Work in Process, 1/1/18 112,300 Direct Labor for 2018 $ 277,300 Ending Finished Goods, 12/31/18 24,400 Ending Raw Materials, 12/31/18 41,250 Ending Work in Process, 12/31/18 122,600 Material Purchases for 2018 306,200 (including $25,000 of indirect material) Note: The pre-determined overhead rate is 0.95 (95%) of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT