S Weatherly Lumber Company processes wood pulp for manufacturing various paper products. The company employs a process costing system for its manufacturing operations. All direct materials are added at the beginning of the process, and conversion costs are incurred uniformly throughout the process. This is the company's production schedule for May: Percent Completed Materials Conversion. 100% 50% Work-in-Process Inventory, May 1 Started during May Units to account for Units from beginning Work-in-Process, which were completed and transferred out during May Started and completed during May Work-in-Process Inventory, May 31 Total units accounted for The following cost data are available: Work-in-Process Inventory, May 1 Direct materials Conversion Costs incurred during May Direct materials Conversion $ 38,010 46,568 168,300 275,380 Tons of Pulp 2,000 11,000 13,000 2,000 6,600 4,400 13,000 100% 50% Required: 1. Calculate the equivalent units of direct materials and conversion during May. Use the FIFO method. 2. Calculate the cost per equivalent unit for both direct materials and conversion during May. Use the FIFO method. Complete this question by entering your answers in the tabs below.

S Weatherly Lumber Company processes wood pulp for manufacturing various paper products. The company employs a process costing system for its manufacturing operations. All direct materials are added at the beginning of the process, and conversion costs are incurred uniformly throughout the process. This is the company's production schedule for May: Percent Completed Materials Conversion. 100% 50% Work-in-Process Inventory, May 1 Started during May Units to account for Units from beginning Work-in-Process, which were completed and transferred out during May Started and completed during May Work-in-Process Inventory, May 31 Total units accounted for The following cost data are available: Work-in-Process Inventory, May 1 Direct materials Conversion Costs incurred during May Direct materials Conversion $ 38,010 46,568 168,300 275,380 Tons of Pulp 2,000 11,000 13,000 2,000 6,600 4,400 13,000 100% 50% Required: 1. Calculate the equivalent units of direct materials and conversion during May. Use the FIFO method. 2. Calculate the cost per equivalent unit for both direct materials and conversion during May. Use the FIFO method. Complete this question by entering your answers in the tabs below.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The El Dorado Star is the only newspaper in El Dorado, New Mexico. Certainly, the Star competes with The Wall Street Journal, USA Today, and the New York Times for national news reporting, but the Star offers readers stories of local interest, such as local news, weather, high-school sporting events, and so on. The El Dorado Star faces the revenue and cost schedules shown in the spreadsheet that follows: A template for the spreadsheet is provided in the Course Materials. You may download my template or create your own. Since we are using dollars and cents, be sure to go out two decimal places on your calculations. Add columns to show, respectively, marginal cost (MC), marginal revenue (MR), and total profit. 1. Dell Computer Corp., the world's largest personal-computer maker, is keenly aware of everything its rival PC manufacturers decide to do. Explain why Dell usually reacts more quickly and more substantially to pricing, product design, and advertising decisions made by…
KSK Company produces backpacks. The company's operations manager, Mehmet Akbalcık, would like to try alternative batch production plans using the data below. Costs Labor cost ($/hour) $12.00 Contract cost ($/piece) $90.00 Retention cost ($/unit-month) $10.00 Hiring cost ($/worker) $500.00 Layoff cost ($/employee) $600.00 Capacity data Current number of workers 200 workers Initial inventory (early January) 300 pieces Labor hours required for a product (product/hour) 5 hours Monthly working hours (employees/month) 160 hours Demand forecasts (units) January 4800 February 5200 March 8500 April 6500 May 4500 June 6200 In the light of these data, apply the following 2 alternative plans by creating tables. Indicate which plan should be preferred. a) Adjusting the labor level each month to produce to meet net demand (Demand monitoring strategy). Contract manufacturing…
The table below provides demand data for 6 weeks (weeks 31-36 for the current year) for one product. Inventory is managed with a periodic review system where T = 5 weeks and M = 280. The previous order was for 120 units at the end of week 28. The lead time is a constant 4 weeks. At the beginning of week 31 the inventory level is 130 units. Orders are made at the end of a week. 1. When is the next order? end of week __________ 2. How large is the next order? ___________ Week Demand Inventory 31 30 32 40 33 45 34 30 35 30 36 30
Barker Company produces and sells a single product with budgeted or standard costs as follows: Inputs Standards Direct materials 10 lbs at $10.00 per pound Direct labor 8 hours at $12.50 per hour Variable factory overhead 8 hours at $20.00 per hour Fixed factory overhead 8 hours at $40.00 per hour Overhead rates are based on 8,000 standard direct labor hours per month, i.e., this is the master budget denominator activity level. Desired ending inventories of materials are based on 10% of the next months materials needed. Desired ending finished goods are based on 5% of next periods budgeted unit sales. Unit Sales are budgeted as follows: January February March April 1,000 1,200 1,600 1,400 The budgeted sales price is $1000 per unit. Sales are budgeted as 80% credit sales and 20% cash sales. Past experience indicates that 60% of credit sales are collected during the month of sale, 38% are collected in the following month, and…
Can the optimal stocking level in the single-period model ever be less than expected demand?Explain briefly.
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: a. Compute the partial productivity measures for chemical for the four periods. b. Compute the partial productivity measures for labor for the four periods.
Prevost Chemicals manufactures an industrial solvent at its only processing plant. A liquid chemical and labor are the two primary inputs. All other resources are included in manufacturing overhead. The plant never has any work-in-process or finished goods inventories. Information from the previous four periods of production follows: Period 1 Period 2 Period 3 Period 4 Chemical input (gallons) 125,000 129,280 128,000 120,000 Labor input (hours) 12,500 11,200 15,000 10,100 Solvent sales (gallons) 110,000 113,120 120,000 103,020 Average price of chemical per gallon $ 2.00 $ 2.10 $ 1.95 $ 2.25 Average wage rate per hour 28.00 26.00 31.00 34.00 Average sales price per gallon 10.26 10.00 9.80 10.60 Manufacturing overhead (total) 236,000 245,312 245,400 243,080 Required: c. Compute the total factor productivity for the four periods.
Anticipated demands for a five-period planning horizon are 14, 3, 0, 26, 15. Current starting inventory is four units, and the inventory manager would like to have eight units on hand at the end of the planning horizon. Assume that h = 1 and K = 30. Find the optimal production schedule. (Hint: Modify the first and the last period’s demands to account for starting and ending inventories.)
Demand for a product is forecasted for the six periods is 263, 256, 301, 312, 304, and 294 respectively. If a CHASE DEMAND strategy is adopted, and the regular production cost is RO 12 per unit with a maximum regular production of 280 units per period. While, the overtime and subcontract costs are RO 20 and RO 25 per unit respectively. There is no limit on subcontracting however, maximum overtime production capacity is 10. Average inventory holding cost is RO 5 per unit per period. What will be the tatal cost of subrontracting the production? Select one: O a 12/5 O b. 19668 O C. RO0 Odo O e. None is correct
The ATV Corporation makes three models of all-terrain vehicles: Model A, Model B, and Model C. Model A uses a 0.4-liter engine, Model B uses a 0.5-liter engine, and Model C uses a 0.6-liter engine. The aggregate production plan is the twelve-month plan that combines all three models together in total monthly production. The planning horizon is twelve months. The APP determines the size of the workforce, which is the constrained resource. Assume that the beginning inventory for January is 120 units (30 units each of Model A and Model B, and 60 units of Model C). The firm desires to have an ending inventory of 160 units at the end of the year. On average, one unit of ATV requires eight labor hours to produce, and a worker contributes 160 hours (8 hours × 5 days × 4 weeks) per month. The data has been collected in the Microsoft Excel Online file attached. Answer the question below: 1. What are the totals of the forecast demand (including inventory adjustment for December), production,…
The objectives of scheduling include all of the following except: A. Increased inventories in order to maximize profits. B. The ability to balance conflicting goals. C. Effective use of facilities, labor, and equipment. D. Costs are minimized by reducing waiting times, work-in-process, and other processing costs related to inventories
This type of problem can be recognized when an order interval is given (e.g.,inventory is ordered every 10 days) along with the demand rate, lead time, and quantity on hand atorder time. A lab orders a number of chemicals from the same supplier every 30 days. Lead time is five days.The assistant manager of the lab must determine how much of one of these chemicals to order. Acheck of stock revealed that eleven 25-milliliter (ml) jars are on hand. Daily usage of the chemical isapproximately normal with a mean of 15.2 ml per day and a standard deviation of 1.6 ml per day. Thedesired service level for this chemical is 95 percent.a. How many jars of the chemical should be ordered?b. What is the average amount of safety stock of the chemical?