Green Lighting Supply plans inventory levels (at cost) at the end of each month as follows: May, $271,000; June $226,000; July $209,000; and August , $241,000. Sales are expected to be June, $449,000; July, $359,000; and August, $306,000. Cost of goods sold is 65% of sales. Purchases in April were $258,000 and in May they were $188,000. Payments for each month's purchases are made as follows: 15% during the month, 70% the next month, and the final 15% the next month.

blem 7-33 Name Section B C D E F G H 5 Data Input Section: Green Lighting Supply 6 Monthly forecasted inventory levels (at cost): 7 May Amount 8 June Amount 9 July Amount 10 August Amount 11 Monthly forecasted sales: 12 June Amount 13 July Amount 14 August Amount 15 Cost of goods sold Amount 16 Purchases: 17 April Amount 18 May Amount 19 Purchases paid for as follows: 20 Current month Amount 21 First month after purchase Amount 22 Second month after purchase Amount 23 Output Section: 24 Purchases Budget 25 June July August 26 Cost of goods sold Formula 1 Formula 5 Formula 9 27 Plus desired ending inventory Formula 2 Formula 6 Formula 10 28 Total needs . - 29 Less beginning inventory Formula 3 Formula 7 Formula 11 30 Equals purchases Formula 4 Formula 8 Formula 12 adsheet to the assignment 3 area Google Doc O e M N 9 S