{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
ang Lieu"
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
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.
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern