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 1Period 2Period 3Period 4Chemical input (gallons)125,000129,280128,000120,000Labor input (hours)12,50011,20015,00010,100Solvent sales (gallons)110,000113,120120,000103,020Average price of chemical per gallon$ 2.00$ 2.10$ 1.95$ 2.25Average wage rate per hour28.0026.0031.0034.00Average sales price per gallon10.2610.009.8010.60Manufacturing overhead (total)236,000245,312245,400243,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. ### Partial Chemical Productivity Measure CalculationThis section is dedicated to computing the partial productivity measures for chemicals over four distinct periods. The productivity measures help in evaluating the efficiency of chemical use during each period.#### Table Overview- **Headers:** - **Period**: This column lists the four periods for which the productivity is to be computed. - **Partial Chemical Productivity**: This column is where the computed productivity measure for each period will be entered.#### Periods Listed1. **Period 1**: - Box available for entering the productivity measure. 2. **Period 2**: - Box available for entering the productivity measure. 3. **Period 3**: - Box available for entering the productivity measure.4. **Period 4**: - Box available for entering the productivity measure.#### Navigation- **Buttons:** - "Required A": Inactive, used for navigating to a different requirement or section. - "Required B": Active, selected to indicate the current focus is on this requirement or section.This content is designed to assist in organizing and calculating productivity data efficiently, ensuring precise chemical management and assessment for each specified period. **Task: Compute Partial Labor Productivity**You are required to compute the partial productivity measures for labor across four periods. Below is a table that needs to be filled in:| **Period** | **Partial Labor Productivity** ||------------|--------------------------------|| Period 1 | || Period 2 | || Period 3 | || Period 4 | |Use the arrows to navigate between different requirements: - `<` Required A- Required C `>`This table provides a structured approach to calculating and inputting the productivity measures for each specified period.

Answered: Prevost Chemicals manufactures an…

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...

	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