Data tableActivity1. Placing and paying for orders ofpencil packs2. Receiving and storage3. Shipping of pencil packs toretailersCost DriverNumber of ordersLoads movedNumber of shipmentsQuantity of Cost per Unit of CostDriverCost Driver8004,5001,500$100 per order$60 per load$70 per shipment Guppy Inc. is a small distributor of mechanical pencils. Guppy identifiesits three major activities and cost pools as ordering, receivingand storage, and shipping, and it reports the following details for 2019:(Click the icon to view the activity and cost pool details.)RevenuesCosts:Begin by calculating the operating income. Then, calculate the per unit amounts. (Round the per unit amounts to the nearest cent.)Purchase cost of pencil packsOrdering costsReceiving and storageShippingTotal costsOperating incomeTotalCPer UnitFor 2019, Guppy buys 250,000 pencil packs at an average costof $3 per pack and sells them to retailers at an average price of$7 per pack. Assume Guppy has no fixed costs and noinventories.Calculate Guppy's operating income for 2019.

Activity Rate :— It is the rate used to allocate manufacturing overhead cost to cost object under…

Inc. is a small distributor of mechanical pencils. Guppy identifies e major activities and cost pools as ordering, receiving prage, and shipping, and it reports the following details for 2019: lick the icon to view the activity and cost pool details.) by calculating the operating income. Then, calculate the per unit amounts. (Round the per unit amounts to the nearest cent.) Per Unit ues chase cost of pencil packs dering costs ceiving and storage pping otal costs ting income For 2019, Guppy buys 250,000 pencil packs at an average cost of $3 per pack and sells them to retailers at an average price of $7 per pack. Assume Guppy has no fixed costs and no inventories. Calculate Guppy's operating income for 2019. Total

Inc. is a small distributor of mechanical pencils. Guppy identifies e major activities and cost pools as ordering, receiving prage, and shipping, and it reports the following details for 2019: lick the icon to view the activity and cost pool details.) by calculating the operating income. Then, calculate the per unit amounts. (Round the per unit amounts to the nearest cent.) Per Unit ues chase cost of pencil packs dering costs ceiving and storage pping otal costs ting income For 2019, Guppy buys 250,000 pencil packs at an average cost of $3 per pack and sells them to retailers at an average price of $7 per pack. Assume Guppy has no fixed costs and no inventories. Calculate Guppy's operating income for 2019. Total

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter2: Descriptive Statistics

Section: Chapter Questions

Problem 3P: Ohio Logistics manages the logistical activities for firms by matching companies that need products...

See similar textbooks

Similar questions

Grouse Inc. is a small distributor of mechanical pencils. Grouse identifies its three major activities and cost pools as ordering, receiving and storage, and shipping, and it reports the following details for 2019: (Click the icon to view the activity and cost pool details.) Data table Activity 1. Placing and paying for orders of pencil packs 2. Receiving and storage 3. Shipping of pencil packs to retailers C Cost Driver For 2019, Grouse buys 250,000 pencil packs at an average cost of $5 per pack and sells them to retailers at an average price of $9 per pack. Assume Grouse has no fixed costs and no inventories. Calculate Grouse's operating income for 2019. Number of orders Loads moved Number of shipments Quantity of Cost per Unit of Cost Cost Driver Driver 600 4,000 1,500 $100 per order $60 per load $90 per shipment X
Quincy Manufacturing reported the following information as of December 31, 2020. Based on actual costs, prepare the company's Schedule of Cost of Goods Manufactured and Sold. Be sure to include a proper heading and to provide necessary supporting calculations. Be sure to label what the numbers in your calculations represent. You will receive at most 50% credit for a correct answer if supporting calculations are not provided. If you upload a document with your answer, please be sure that your name appears at the top of the document. You will not receive credit if your name isn't on any attachment. Beginning Raw Materials Inventory$22,000Ending Raw Materials Inventory$27,000Indirect Materials Used$27,000Selling and Administrative Expenses$409,000Factory Rent$68,000Beginning Work in Process Inventory$33,000Ending Work in Process Inventory$25,000Net Delivered Cost of Materials Purchased$210,000Direct Labor Wages$325,000Production Equipment Depreciation$95,000Factory Supplies…
The following information is available for the Murphy Manufacturing company for 2020. (Click the icon to view the information.) Requirement Assume that all raw materials are purchased on credit and all sales are credit sales. Compute the missing amounts above. Accounts receivable, January 1, 2020 Accounts payable, January 1, 2020 Raw materials, January 1, 2020 Work in process, January 1, 2020 Finished goods, January 1, 2020 Accounts receivable, December 31, 2020 Accounts payable, December 31, 2020 Raw materials, December 31, 2020 Work in process, December 31, 2020 Finished goods, December 31, 2020 Raw materials used in production Raw materials purchased Accounts receivable collections Accounts payable payments Sales Total manufacturing costs Cost of goods manufactured Cost of goods sold Gross margin Data table Accounts receivable, January 1, 2020 Accounts payable, January 1, 2020 Raw materials, January 1, 2020 Work in process, January 1, 2020 Finished goods, January 1, 2020 Accounts…
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?
Calculating income and cost per unit for a merchandising company Conway Brush Company sells standard hair brushes. The following information summarizes Conway’s operating activities for 2018: Requirements Calculate the operating income for 2018. Conway sold 6,600 brushes in 2018. Compute the unit cost for one brush.
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's Manufacturing Income Statement Month ending August 31, 2019 Dept. A Dept. B Sales $22,000 $51,000 Cost of Goods Sold 10,560 26,520 Gross profit $11,440 $24,480 Utility expenses 1,000 3,200 Wages expense 5,500 10,200 Costs allocated from Corporate 2,200 15,000 Total expenses $8,700 $28,400 Operating Income/(loss) $ ? ? Operating income/(loss) % ? ? Which of these costs may need further…
You are given the information below and you are requested to answer the following questions (keep your calculations at a side paper because you might need them to answer other questions also): Beginning finished goods, 1/1/2019 $ 90,000 Ending finished goods, 31/12/2019 $ 77,000 Cost of goods sold $ 270,000 Sales revenue $ 500,000 Operating expenses $ 155,000 Question: What is gross margin for 2019?
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's ManufacturingIncome StatementMonth Ending August 31, 2018
Oliver Brush Company sells standard hair brushes. The following information summarizes Oliver's operating activities for 2018: Requirements 1. Calculate the operating income for 2018 2. Oliver sold 5,400 brushes in 2018. Compute the unit cost for one brush.
The following information has been extracted from the cost accounting information system database for Victoria Furnitures Ltd. The company manufactures different types of furniture’s, including tables; The company manufactured 1,000 tables during the year 2020. Required: Using the information provided in the above table identify and explain how you classify each of the above costs according to the functional approach; Use the tables as the cost object in the classification of the costs.