Excel 2 questions

Please look into the pictures i attached.
The two questions must be answered in EXCEL file.

“For question 4 (aggregating planning) on your homework, since no selling price is provided in the question, skip calculating revenue and profit. Only get the total cost

Thanks.

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started