Budgeting homework:

1)

Spotlight would like to start each month with 10%% of its planned sales on hand in Finished Goods, Accordingly. their budgeted production is as follows: PRODUCTION BUDGET [in units) September October November December Budgeted Sales (units) 18,000 15.000 12,000 15,000 . Desired Ending Inv. 1,500 1.200 1.500 600 Planned Need (units) 19.500 16,200 13,500 15,600 . Beginning Inventory (1.800) (1.500) (1.200) (1.500) Budgeted Production (units) 17.700 14.700 12.300 14.100 Each GPx requires 4 LED bubs, two red and two white. At the beginning of each month, Spotlight would like to have 20% of the bulbs on hand for that month's production. How many bulbs are needed for October Production? How many bulbs are needed for November Production? How many bulbs are needed in October's Ending Inventory? How many bulbs are needed in November's Ending Inventory?The cost of each bulb is $1.08, regardless of color. The red and white bulbs, however, come from different suppliers. The red bulb supplier offers a 5% discount for prompt (within the same month) payment. As such, Spotlight pays for all red bulbs in the month of purchase. Spotlight pays for all white bulb purchases in the month after purchase. Assume the Accounts Payable balance for bulbs on September 30th is $36.936.00 and on October 31st is $30,715.20. Based on your purchasing requirements determined in Question 4 above, and the A/P balances listed, what are the total payments to be made to bulb suppliers in November