HEY if it is possible may you show your formulas??
Thank youuuu
Part 1 | |||||
Calculation of Activity Rate | |||||
Activity | Activity Cost(Col 1) | Cost Driver(Col 2) | Activity Rate(Col 1 / Col.2) | ||
Customer Service | $ 91,080 | 330 Service requests | $ 276.00 | Per service requests | |
Project Bidding | $ 58,900 | 100 Bids | $ 589.00 | Per Bids | |
Engineering Support | $ 84,018 | 209 customer design changes | $ 402.00 | Per customer design changes | |
Part 2 | |||||
Allocation of Activity Costs | Activity Rate * Activity-Base Usage | ||||
Activity Rate | Gough Industries | Breen Inc. | Group | Total | |
Customer Service | $ 276.00 | $ 17,388 | $ 15,456 | $ 58,236 | $ 91,080 |
Project Bidding | $ 589.00 | $ 20,615 | $ 11,191 | $ 27,094 | $ 58,900 |
Engineering Support | $ 402.00 | $ 16,884 | $ 12,462 | $ 54,672 | $ 84,018 |
Part 3 | |||||
Customer Profitability Report | |||||
For the Year ended December 31 | |||||
Gough Industries | Breen Inc. | Group | Total | ||
Revenue(Unit Volume*$74,900) | 1797600 | 1048600 | 374500 | 3220700 | |
Cost of goods sold((Unit Volume*$60,550) | 1453200 | 847700 | 302750 | 2603650 | |
Gross Profit | 344400 | 200900 | 71750 | 617050 | |
Selling & Administraitive activitites: | |||||
Customer Service | $ 17,388 | $ 15,456 | $ 58,236 | $ 91,080 | |
Project Bidding | $ 20,615 | $ 11,191 | $ 27,094 | $ 58,900 | |
Engineering Support | $ 16,884 | $ 12,462 | $ 54,672 | $ 84,018 | |
Total Selling & Administraitive activitites | $ 54,887 | $ 39,109 | $ 1,40,002 | $ 2,33,998 | |
Income from Operations | $ 2,89,513 | $ 1,61,791 | $ -68,252 | $ 3,83,052 | |
HEY if it is possible may you show your formulas?? Thank youuuu Arctic Air Inc. manufactures...
Allocating Selling and Administrative Expenses using Activity-Based Costing Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Price $60,000 per unit Cost of goods sold (28,000) Gross profit $32,000 per unit In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to...
Allocating selling and administrative expenses using activity based costing Labels and Amount Descriptions Activity rates Activity Costs Customer Profitability Report Suced ceils have feedback 3. Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (). The reports should disclose the gross profit and income from operations associated with each customer Refer to the list of Lisbets and Amount Descriptions for the exact wording of the answer choices for text...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $710 per unit Cost of goods sold 430 Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $233,460. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $700 per unit Cost of goods sold 420 Gross profit $280 per unit In addition, the company incurs selling and administrative expenses of $284,420. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $670 per unit Cost of goods sold 400 Gross profit $270 per unit In addition, the company incurs selling and administrative expenses of $290,680. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related...
U W Calculator Printem Allocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price Cost of goods sold $1,110 per unit 682 Gross profit $428 per unit In addition, the company incurs selling and administrative expenses of 5414.030. The company wishes to assign these costs to its three major retail customers. The Warehouse, Komo com and Supply Universe....
Instructions Three Rivers Inc. provides cable TV and Internet service to the local community. The activities and activity costs of Three Rivers are identified as follows Activities Activity Cost 36,000.00 Biling error correction Cable signal testing 1,800.00 Reinstalling service (installed incorrectly the first time 8,00000 Repairing satellite equipment 7,800.00 Repairing underground cable connections to the customer 1700000 Replacing old technology cable with higher quality cable 169,000.00 ! Replacing old technology signal switches with higher quality switches 126,00000 9Responding to customer...
#9
Instructions Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Activity Rate Customer Service Activity Bid preparation Activity Base Number of bld requests $400 per request Shipment $80 per shipment Support standard items Support nonstandard Items Number of shipments Number of standard items ordered Number of...
Joplin Industries Inc. manufactures and sells high-quality sporting goods equipment under its highly recognizable J-Sports logo. The company began operations on May 1 and operated at 100% of capacity (88,000 units) during the first month, creating an ending inventory of 6,000 units. During June, the company produced 80,200 garments during the month but sold 86,200 units at $92 per unit. The June manufacturing costs and selling and administrative expenses were as follows: Number of Units Unit Cost Total Cost Manufacturing...
Hello! I need helping filling out the blank portions in the
income statement below. Thank you in advance!
Instructions The revenues and expenses of Paradise Travel Service for the year ended May 31, 2018, follow: Accounts (revenue and expense items) $900,000 Fees earned Office expense 300,000 Miscellaneous expense 15,000 Wages expense 450,000 Prepare an income statement for the year ended May 31, 2018. Refer to the lists of Accounts in the information given, Labels, and Amount Descriptions for the exact...