Overview Fragrantfood is a manufacturer of artisan bread and buns. The production operates daily from $8\mathrm{.}00$ am to $6\mathrm{.}00$pm with $1$ hour lunch break at $12$pm $($no production during lunch time$).$ FragrantFood receives daily order demand of $8,000$ buns on average. Its high$-$quality buns gradually lead to increase in order demand. The production manager, Mr Tang, is required to manage the resources and customers' demand weekly to ensure smooth production to meet $100\%$ of the order demand. Fragrantfood employs full time staff and interns for their production operation. Their productivity and daily wages are shown in Table $1$ below: As an intern at FragrantFood, you are tasked to develop a Production Model using MS Excel application to provide quick turnaround of data to support Mr Tang's weekly decision making. Show the calculation for each of the Output field with an example. $1.$ Excel Production Model $($Total $25$ marks$)($Submit the model in MS Excel Format$)$ Requirement $1-$ Input Fields $(5$ marks$)$ Your model should allow Mr Tang to enter below input varlables: $1.$ Production requirement $($no$.$ of buns needed$)$ for the day. $2.$ No$,$ of workers available for each worker type. $3.$ Per hour throughput for each worker type. $($You can create additional input fields to enhance your model$)$ Requirement $2-$ Output Fields $(10$ marks$)$ Your model should produce output$/$ information as shown below:

$1.$ Cumulative volume of hourly production.

$2.$ Appropriate chart showing the hourly throughput $($cumulative production$).3.$ KPI achieved by end of the day $($cut$-$off time is at $6\mathrm{.}00$pm $).($You can create additional output fields where necessary$)$ Requirement $3-$ Creativity $(4$ marks$)$ Enhance your model$-$to improve its usability. Some examples $($but not limited to below$)$ are as follows: $-$ Additional output data fields useful for day$-$to$-$day decision making. $-$ Additional functions $($eg$.$ buttons, drop down list, filters$)$ to improve usability of the model. $-$ Meaningful Graphics$/$ Colour code to differentiate data types.