{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tut_05_Modeling_filter

# Tut_05_Modeling_filter - Tutorial 4 Content 1 Cr eate a...

This preview shows pages 1–6. Sign up to view the full content.

Tutorial 4 Content 1. Create a model of Lang Lieu chung cake as instructed in worksheet "L 2. Go to "05-1" and complete requirements there. Remark: yellow text are optional exercises

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
ang Lieu"

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Problem: Lang Liêu is the owner of a family business that every day makes and sells Chung Vietnamese food. He needs to build an Excel model to control and evaluate the business. He has gathered the following information: Two types of cakes were made: savoury and sweet All the cakes that are made will be sold out on the same day (because the numbe on the real demand registered in advance) Currently, Lang Liêu makes 50 savoury cakes and 20 sweet cakes a day and sells VND15,000 and a sweet cake for VND8,000. To make a savoury cake, 0.3kg sticky rice, 0.2kg pork meat, 0.15kg green bean a To make a sweet cake, 0.3kg sticky rice, 0.05kg sugar, 0.1kg green bean are need Each cake, either savoury or sweet will need 3 leaves (lá dong) The labour cost per savoury cake is VND500 and per sweet cake is VND300. The current boiling cost for a pot is VND30,000 and each pot can be used to cook sweet or both. Cake types are boiled together. The same cost VND30,000 is appli i.e.: if Lang Liêu needs to cook only 5 cakes, the cost is still VND30,000. Lang Liêu is currently buying green bean at VND10,000/kg, sticky rice at VND8,00 VND40,000/kg, sugar at VND9,000/kg and dong leaves at VND100/leaf Requirements: a)With the above current information, use a calculator to calculate the revenues, and loss, average profit and loss per cake type and per cake unit.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern