Assalamualaikum wbt.
Today, me and my teammates just needed to update on how our contact with the food service establishments that we have choosen. Basically, we have contacted them, but we haven't yet get the official response whether they are willing to join the GOMC. So, we are currently waiting their confirmation.
Today also we had received the official letter for the GOMC. With the letter, we can showed to the companies the legitimate of this event. Starting today also, we needed to register the team in the GOMC under the supervision of Dr. Fareed Ismail. Dr. Fareed gave us one week for us to register for GOMC, and select one company of our picks for the GOMC.
LAB ASSIGNMENT FSM4503 #2
For this week lab, we were taught by Dr. Fareed how to use menu item cost calculator and how to create our own menu cost card using the Microsoft Excel.
This lab session is actually the continuation of last week lab on how to use sum and multiply function for advance usage. The objective of this lab session is
1) to design a menu item cost calculator to calculate the total cost of a meal,
2) to calculate the total cost of primary & secondary ingredients and the utility and preparation costs for a meal and make it as a pie chart, and
3) to provide the instruction of the meal preparation and insert the photo of the dish.
At first, I don't know how to handle the mechanics in the menu cost calculator. But after some explanations by Dr. Fareed on how to change the calculating formula of the functions in the menu card, I gradually able to understand and handle the menu cost card, yet I still need some practice and learning to adapt myself with the calculation in Microsoft Excel.
To me, the benefit of creating menu cost calculator and menu cost card using Microsoft Excel is that it simplifies how we create a menu card. In a menu card, we need to have the ingredients, the costs and the costs of the ingredient in per units. Then, we need to calculate the selling price and profits margin of selling the product. It takes some time if we create the menu card by hand as we need to calculate one by one from the start 'till the end. But by using Mircrosoft Excel which have formulas and functions, we could save some time in creating menu card as the calculating algorithms have been made by the computer. We do not need to calculate one by one to create a menu card.
My example of menu cost card using the menu cost calculator method
No comments:
Post a Comment