Chapter 14, Problem 1CQ

What might Stephanie determine as the best production quantity per cycle for each day of the week?

Summary Introduction

To determine: The production sequence for cycle are S7, S8, S9, S1 and S2.

Introduction: A production cycle is a period through which the factors required by labors such as raw materials and goods stay in the creation process from the initial starting point of assembling through yield of finished goods.

Answer to Problem 1CQ

The production sequence for cycle S7 is 48, S8 is 90, S9 is 25, S1 is 120 and S2 is 102.

Explanation of Solution

Given Information:

Model	Weekly Quantity
S1	120
S2	102
S7	48
S8	90
S9	25

The department operates five days a week. The production sequence is S7-S8-S9-S1-S2.

Calculate the daily demand for each model:

The demand for each model is calculated by dividing daily quantity of each model with total operational days.

$\begin{array}{c}\mathrm{Daily}{\mathrm{Demand}}_{\text{S}1}=\left[\frac{\mathrm{Daily}{\mathrm{Quantity}}_{\text{S}1}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{120}{5}\right]\\ =24\end{array}$

$\begin{array}{c}\mathrm{Daily}{\mathrm{Demand}}_{\text{S}2}=\left[\frac{\mathrm{Daily}{\mathrm{Quantity}}_{\text{S}2}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{102}{5}\right]\\ =20.4\end{array}$

$\begin{array}{c}\mathrm{Daily}{\mathrm{Demand}}_{\text{S}7}=\left[\frac{\mathrm{Daily}{\mathrm{Quantity}}_{\text{S}2}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{48}{5}\right]\\ =9.6\end{array}$

$\begin{array}{c}\mathrm{Daily}{\mathrm{Demand}}_{\text{S}8}=\left[\frac{\mathrm{Daily}{\mathrm{Quantity}}_{\text{S}8}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{90}{5}\right]\\ =18\end{array}$

$\begin{array}{c}\mathrm{Daily}{\mathrm{Demand}}_{\text{S}9}=\left[\frac{\mathrm{Daily}{\mathrm{Quantity}}_{\text{S}9}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{25}{5}\right]\\ =5\end{array}$

Calculate the number of units per cycle for each model

It is calculated by dividing the daily demands with total operational days.

$\begin{array}{c}\mathrm{Number}\mathrm{of}\mathrm{Units}{\text{s}}_1=\left[\frac{\mathrm{Daily}{\mathrm{Demand}}_{\text{S}1}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{24}{5}\right]\\ =4.8\end{array}$

$\begin{array}{c}\mathrm{Number}\mathrm{of}{\mathrm{Units}}_{\text{S}2}=\left[\frac{\mathrm{Daily}{\mathrm{Demand}}_{\text{S}2}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{20.4}{5}\right]\\ =4.08\end{array}$

$\begin{array}{c}\mathrm{Number}\mathrm{of}{\mathrm{Units}}_{\text{S}7}=\left[\frac{\mathrm{Daily}{\mathrm{Demand}}_{\text{S}7}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{9.6}{5}\right]\\ =1.92\end{array}$

$\begin{array}{c}\mathrm{Number}\mathrm{of}{\mathrm{Units}}_{\text{S}8}=\left[\frac{\mathrm{Daily}{\mathrm{Demand}}_{\text{S}8}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{18}{5}\right]\\ =3.6\end{array}$

$\begin{array}{c}\mathrm{Number}\mathrm{of}{\mathrm{Units}}_{\text{S}9}=\left[\frac{\mathrm{Daily}{\mathrm{Demand}}_{\text{S}9}}{\mathrm{Operational}\mathrm{Days}}\right]\\ =\left[\frac{5}{5}\right]\\ =1\end{array}$

Calculate the production quantity per cycle for each day for 5 days from Monday to Friday. 

This can be subjective. Production cycle should be on the sequence S7-S8-S9-S1-S2 done each cycle. We attempted to produce the same aggregate amount of units for every cycle. Whether this might have been not possible, we attempted with plan fewer units on the most last cycle of a day will consider getting up every day.

Excel Spreadsheet:

   

Calculate the production quantity per cycle for each model:

It is calculated by adding all the total values of each cycle from Monday to Friday.

$\begin{array}{c}\mathrm{Production}\mathrm{Quantit}{y}_{\text{S}7}=\left[10+10+10+10+8\right]\\ =48\end{array}$

$\begin{array}{c}\mathrm{Production}\mathrm{Quantit}{y}_{\text{S}8}=\left[18+18+18+18+18\right]\\ =90\end{array}$

$\begin{array}{c}\mathrm{Production}\mathrm{Quantit}{y}_{\text{S}9}=\left[5+5+5+5+5\right]\\ =25\end{array}$

$\begin{array}{c}\mathrm{Production}\mathrm{Quantit}{y}_{\text{S}1}=\left[24+24+24+24+24\right]\\ =120\end{array}$

$\begin{array}{c}\mathrm{Production}\mathrm{Quantit}{y}_{\text{S}1}=\left[21+21+21+21+18\right]\\ =102\end{array}$

Hence, the production sequence for cycle S7 is 48, S8 is 90, S9 is 25, S1 is 120 and S2 is 102.