Answer:
[tex]\left[\begin{array}{ccccc}&January&February&March&Quarter\\$sales&24500&37700&32500&94700\\$Desired ending&9425&8125&3462.5&3462.5\\$Total Needs&33925&45825&35962.5&115712.5\\$beginning&2770&9425&8125&2770\\$Production Requirement&31155&36400&27837.5&95392.5\\\end{array}\right][/tex]
Explanation:
We need to recalcualte the desired ending inventory
as currently they are calcualte at 20% and we want it at 25% we do cross multiplication
Jan: 7,540 / 20 x 25 = 9,425
We divide by 20 to get the value of a single percent f sales and then we multiply to 25 as it is our desired amount
Feb: 6,500 / 20 x 25 = 8,125
March: 2,770 / 20 x 25 = 3,462.5
Next we adjsut6 the beginning inventory for January as it is 2,770 instead of 4,900 and we can determiante the production budget need for the quarter