Problem $13-3($Algo$)$

The Johnson Company manufactures expensive medical diagnostic equipment. It plans to

meet all of its projected demand $($given below for the next year by quarter$).$ The firm plans to

use a constant production rate of $300$ units$/$quarter$.$ Production costs are $$17,500$ per unit and

holding costs are $$1,400$ per quarter per unit. Assume no on$-$hand inventory exists at the

beginning of Quarter $1.$

PictureClick here for the Excel Data File

a$.$ Find the regular production and ending inventory. $($Leave no cells blank $-$ be certain to enter

$"$O$"$ wherever required.$)$

b$.$ What is the cost of this production plan?