Answer the following questions:
- Given the current situation, what product mix should AppleBerry use to maximize its monthly profits? What is the optimized monthly profit? Set this up as a spreadsheet using Solver.
- If AppleBerry chooses to commit more resources to increase profits, should it purchase more fabrication time, assembly time, machining time, or raw materials?
deviceNo of devicesMp3 player1E reader198tablet50(1*16)+(198*20)+(50*14)=$4676To obtain a profit of $4676b) it should increase the number of raw materials at production, to maximize…