Question

I nned hand calculation

For 2020, a small grocery store predicts it will sell crates of apples and oranges as shown in Table 1 (may be downloaded from Blackboard). Write a macro to help the store manager estimate 2020 profits. The grocer's profits vary by season and are summarized in Table 2. If profit falls below S90 in any given month, the manager can't pay his electric bill, so your program should output months where this occurs. Your program should also output the most profitable and least profitable months as well as monthly and annual profits. Table 1. Estimated 2020 Sales (by Crates) Month Apples Oranges January 30 30 February 2926 March 3239 April 48 May June July August September October November December 39 38 32 50 28 Table 2. Grocer Seasonal Profits Per Crate Season Apples Oranges Winter Dec. to Feb.) $1.50 52.00 Spring (Mar. to May) SL.00 $1.50 Summer (June to Aug.) $1.00 $1.50 Fall (Sep. to Nov.) $1.25 $1.50

Answer 1

Particulars	January	February	March	April	May	June	July	August	September	October	November	December
Apples (No of crates)	30	29	32	48	40	39	44	39	29	39	38	32
Oranges (No of crates)	30	26	39	25	38	34	33	45	32	50	28	26
Apples (Profit per crate)	$1.50	$1.50	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.25	$1.25	$1.25	$1.50
Oranges (Profit per crate)	$2.00	$2.00	$1.50	$1.50	$1.50	$1.50	$1.50	$1.50	$1.50	$1.50	$1.50	$2.00
Total profit per month from sale of Apples	$45.00	$43.50	$32.00	$48.00	$40.00	$39.00	$44.00	$39.00	$36.25	$48.75	$47.50	$48.00
Total profit per month from sale of Oranges	$60.00	$52.00	$58.50	$37.50	$57.00	$51.00	$49.50	$67.50	$48.00	$75.00	$42.00	$52.00
	$105.00	$95.50	$90.50	$85.50	$97.00	$90.00	$93.50	$106.50	$84.25	$123.75	$89.50	$100.00	$1,161.00
Months where the profit falls below $90, April September & November can be seen from above calculation
Most profitable month is October with total profit of $ 123.75
Least profitable month is September with total profit of $ 84.25
Annual profit is $ 1,161, monthly profit is already shown in the above computation