Preparing the quarterly cash budgets of the next year, obtained the flowwing sales forecasts from the marketing department, indicate if there is a need of cash borrowing, if yes compute the need of loan:
1.Quarter 2.Quarter 3.Quarter 4.Quarter 1.Quarter of
Year After
Sales Forecasts 18.000 U. 20.000 U. 25.000 U. 22.000 U. 30.000 U.
Unit sale price will be $18 and expected to collect 1/2 cash ¼ 1 month, 2 months later. In the production of one unit end product 4 units of direct material will be used. Marketing department needs a 15% end product stock of the following period sales at the end of every period. Manufacturing department needs a 20% direct material stock of the material to be used in the following period production at the end of every period. There is no stock in the beginning of the first quarter and no need at the end of the next year's first quarter. Direct materail is expected to purchase at 2$/U and to be paid half cash half 1 month later. Direct labor is budgeted as the half of the direct material cost and will be paid in cash. Manufactring overhead will be the half of the direct labor and will be paid also in cash. There is no cash in the beginning, and no need at the end of year.
