Chapter 5-Worksheet - Class Demo

xlsx

School

Southern Alberta Institute of Technology *

*We aren’t endorsed by this school

Course

338

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

27

Uploaded by BrigadierElephantPerson1096

Report
JOB COSTING Direct materials xx Direct labour xx Indirect manufacturing overhead xx Total manufacturing cost xx MOH : Should be allocated (Bases). Direct Manufacturing Labour Hours DMLH Machine Hours MH Direct Labour Cost DLC
MOH
Cost Pool Overhead Costs Supervision of direct labour $320,000 Machine maintenance $120,000 Facility rent $200,000 Total overhead costs $640,000 Cost driver Actual level Direct labour-hours 200 Machine-hours 1,600 Square metres of area 50 a $640,000 800,000 Indirect Cost = MOH Rate x Actual Base = (200 * 0.8) b Cost Pool Overhead Costs Supervision of direct labour $320,000 Machine maintenance $120,000 Facility rent $200,000 SP Gregory Enterprises has identified three cost pools to allocate overhead co provided for the coming year: The accounting records show the Mossman Job consumed the following r If Gregory Enterprises uses a simple cost system based on direct labour indirect costs will be allocated to the Mossman job? MOH_Rate = (BMOH _Cost / Base) = If Gregory Enterprises uses an ABC system t hen what amount of indirect Mossman job?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
DM DML MOH
Cost driver Activity level Direct labour hours 800,000 Machine hours 960,000 Square metres of area 100,000 total overhead cost / direct labour hours moh rate $0.80 DLH $160.00 Activity level ABC_Rate Actual level ABC _Cost 800,000 $0.40 200 $80 960,000 $0.13 1,600 $200 100,000 $2.00 50 $100 ABC Indirect _Cost $380 $360.00 $360.00 osts. The following estimates are resources: hours t hen what amount of costs will be allocated to the
Trad ABC $10.00 $10 $10.00 $10 $160.00 $380 $180.00 $400.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Page 158 (Q5-20) Mathematical Financial 50000 100,000 Direct material costs $220,000 $440,000 Direct manufacturing labour costs $85,000 $170,000 Cost Drivers Mathematical Financial Machine-hours 31250 62,500 Number of production runs 50 50 Inspection hours 1350 675 Total manufacturing overhead costs are as follows: Total Machining costs $384,375 Setup costs 130000 Inspection costs 129600 $643,975 Required 1 Activity Cost Driver MOH_Cost ($) Machining Machine-hours $384,375 Setup #of production runs 130000 Inspection Inspection hours 129600 MOH_Cost/Unit 5-20 ABC, process costing. Sander Company produces mathematical and finan Annual production in units Choose a cost drive r for each overhead cost pool and calculate the manufacturi
Total Cost Drivers Mathematical Financial Machine-hours 31250 62,500 #of production runs 50 50 Inspection hours 1350 675 2 Mathematical Financial Direct material costs (DM) $220,000 $440,000 Direct manufacturing labour costs (DL) $85,000 $170,000 50000 100000 Manufacturing Cost/Unit Mathematical Financial DM_Cost/unit $4.40 $4.40 DL_Cost/Unit $1.70 $1.70 MOH_Cost/Unit 5.59 3.64 $ 11.69 $ 9.74 3. How might Sander’s managers use the new cost informatio Annual production in units Compute the manufacturing cost per unit for each product. Annual production in units Managers can see the details that can help in managing cost effectivel Helps in Pricing and Product mix decision Helps with cost reduction and process improvement process decision
DM/unit $ 4.40 DML MOH TOTAL 93,750 100 2,025 Total Cost Driver ABC Rates ($) 93,750 $ 4.10 100 $ 1,300.00 2,025 $ 64.00 ncial calculators and operates at capacity. Data related to the two products are presented he ing overhead cost per unit (MOH_Cost/Unit) for each product.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ABC Rates ($) Mathematical Financial 4 128125 256250 1,300 65000 65000 64 86400 43200 Total MOH $ 279,525.00 $ 364,450.00 $643,975 MOH_Cost/Unit $ 5.59 $ 3.64 on from its activity-based costing system to better manage its business ly n
ere:
s?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Activities ABC - Cost rates Ordering $102 Delivery and receipt of merchandise $78 Shelf-stocking $21 Customer support and assistance $0.22 The revenues, cost of goods sold, store support costs, activities tha Baked Goods Financial data(Income Statement) Revenues $61,500 Cost of goods sold $36,000 Store support(opex) $10,800 Activity-area usage (cost-allocation base) Ordering (purchase orders) 44 Delivery (deliveries) 120 Shelf-stocking (hours) 170 Customer support (items sold) 15400 Required 1 Financial data Baked Goods Revenues $61,500 Cost of goods sold $36,000 Store support $10,800 Operating income $14,700.0 5-26 ABC, r etail product-line profitability. Fitzgerald Superma frozen foods. It identifies four activities and their activity cost r Under its simple costing system, FS allocated support costs to prod Use the s imple costing system to prepare a product-line profita
Ranking 2.0 Operating income ÷ Revenues 23.90% 2 Determine the ABC Support cost; Activity-area usage (cost-allocation base) Baked Goods Ordering (purchase orders) 25 Delivery (deliveries) 90 Shelf-stocking (hours) 190 Customer support (items sold) 13500 ABC Profit Analysis Financial data Baked Goods Revenues $61,500 Cost of goods sold $36,000 Store support - ABC $16,530 30% OF COGS Operating income $8,970 Ranking 3.0 Operating income ÷ Revenues 14.59% Profit Analysis Ranking ABC Costing (Module 1 Frozen Products 2 Milk and Fruit Juice 3 Baked Goods DECISION: Use the ABC system to prepare a product-line profitability rep
per purchase order per delivery per hour per item sold at account for the store support costs, and activity-area usage of the three product line Milk and Fruit Juice Frozen Products $77,500 $60,500 $48,000 $34,000 $14,400 $10,200 Actual level 24 14 60 36 150 20 20200 7960 Milk and Fruit Juice Frozen Products $77,500 $60,500 $48,000 $34,000 $14,400 $10,200 $15,100.0 $16,300.0 arkets (FS) operates at capacity and decides to apply ABC analysis to three prod rates as follows: ducts at the rate of 30% of cost of goods sold. ability report for FS.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3.0 1.0 19.48% 26.94% Traditional Method Actual level Milk and Fruit Juice Frozen Products ABC Cost rates Baked Goods 20 15 $102 $2,550 35 30 $78 $7,020 180 40 $21 $3,990 17500 8000 $0.22 $2,970 ABC SUPPORT $16,530 Milk and Fruit Juice Frozen Products $77,500 $60,500 $48,000 $34,000 $12,400 6470 $17,100 $20,030 23.11% 2.0 1.0 22.06% 33.11% Percentage (%) Simple Costing Percentage (%) 33.11% Frozen Products 26.94% 22.06% Baked Goods 23.90% 14.59% Milk and Fruit Juice 19.48% port for FS.
es are as follows: duct lines: baked goods , milk and fruit juice, and
Support ABC Cost Milk and Fruit Juice Frozen Products $2,040 $1,530 $2,730 $2,340 $3,780 $840 $3,850 $1,760 $12,400 $6,470
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ABC RATES Ordering $120 Delivery and receipt of merchandise Shelf-stocking Customer support and assistance 0.24 The revenues, cost of goods sold, store support costs, and activity area u Baked Goods Financial data: Revenues $78,400 Cost of goods sold 45600 Store support 13680 Activity area usage (cost driver): Ordering (purchase orders) Delivery (deliveries) Shelf-stocking (hours) Customer support (items sold) There are no bottle returns for any of these three product lines. Required Financial data Baked Goods Revenues $78,400 Cost of goods sold 45600 Store support 13680 5-33 Use ABC systems for ABM . Family Supermarkets (FS) found tha provided important insights. FS extends the analysis to cover three more identifies four activities and activity cost rates for each activity as     96     24         30         98       183  15,500 1. Use the previous costing system (support costs allocated to products a profitability report for FS.
Operating income $19,120.0 Operating income ÷ Revenues 24.39% 2 2 Use the ABC system to prepare a product-line profitability report f Determine the ABC Support cost; Activity-area usage (cost-allocation base) Baked Goods Ordering (purchase orders) 30 Delivery (deliveries) 98 Shelf-stocking (hours) 183 Customer support (items sold) 15500 ABC Profit Analysis Financial data Baked Goods Revenues $78,400 Cost of goods sold 45600 Store support $21,120 Operating income $11,680 Operating income ÷ Revenues 14.90% 3 Profit Analysis Ranking ABC Costing (Modul 1 Frozen Products 2 Milk and Fruit Juice 3 Baked Goods
per purchase order per delivery per hour per item sold usage of the three product lines are as follows: Milk and Fruit Juice Frozen Products $85,600 $72,400 56400 42000 16920 12600 Milk and Fruit Juice Frozen Products $85,600 $72,400 56400 42000 16920 12600 at its ABC analysis (see the Pulling It All Together problem in this chapter) e product lines: baked goods, milk and fruit juice, and frozen products. It         25         13         36         28       166         24  20,500    7,900 at the rate of 30% of cost of goods sold) to compute a product line
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$12,280.0 $17,800.0 14.35% 24.59% 3 1 for FS. Actual level Milk and Fruit Juice Frozen Products ABC Cost rates 13 $120 28 96 24 24 7900 0.24 Milk and Fruit Juice Frozen Products $85,600 $72,400 56400 42000 $15,360 6720 $13,840 $23,680 16.17% 32.71% 2 1 Percentage (%) Simple Costing Percentage (%) Frozen Products Baked Goods Milk and Fruit Juice         25         36       166  20,500
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Activity area usage (cos Baked Goods Milk and Fruit JuicFrozen Products Ordering (purchase or Delivery (deliveries) Shelf-stocking (hours Customer support (ite         30         25         13         98         36         28       183       166         24  15,500  20,500    7,900
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Support ABC Cost Baked Goods Milk and Fruit Juice Frozen Products $3,600 $1,560 $9,408 $2,688 $4,392 $576 $3,720 $1,896 $21,120 $15,360 $6,720
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ABC cost rate $120 0.24     96     24
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help