Budget

  Initial Situation 

Hospitable co provides the following sales for the next 4 months

                           April May June  July

Sales unit   500      580   540    620

The company wants to end each month with ending finished goods inventory equal to 25% of next months sales. Finished goods inventory on April 1 is 190 units . Assume July’s budgeted production is 540 units. Preapare production budget for the month’s of April, may and june

         for this assignment please explain in detail the initial   situation the requirements then provide complete solution to the questions   explained on calculations and provide four scholarly references and text book   as reference for the data  and report should be  4-5 pages . 

Solution : is attached in the excel sheet