Excel 2 questions

by

Business Finance

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.