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

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Tutorial 4 Content 1. Cr eate a model of Lang Lieu chung cake as instr ucted in work sheet "L 2. Go to "05-1" and complete r equir ements ther e. Remark: yellow text ar e optional exer cises ang Lieu" Pr oblem: 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 Requir ements: 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. b)Help Lang Liêu set up an Excel template so that he can use that template every the above information can change, so the template must have a separate Input when needed. g cake- a typical type of daily operation of his er of cakes is decided based s a savoury cake for re needed. ded. k 20 cakes, either savoury or lied even if the pot is not full, 00/kg, pork meat at , costs, total profit ry day. Remember that most of Section for Lang Liêu to edit Internal Assessment - Business Modeling Created by Nguyen Van A Updated 14-Sep-11 *CP: Class Participation / TP: Tutorial Performance / P: Presentation / IA: Internal Assessment / A: Absent STT Student ID CP TP Midterm P IA Note 10% 10% 15% 15% (over 5) 1 0304000038 7 6 4.25 6.5 2.91 6.00 2 0304000106 8 7.75 3.25 8 3.26 7.50 3 0404000023 3 0.30 4 0504000040 8 4.25 5 7.5 3.10 3.50 5 0504000099 4.5 5.25 8.5 2.51 7 0504000115...
View Full Document

This note was uploaded on 09/16/2011 for the course ASD 2314 taught by Professor Asdfasdf during the Spring '11 term at Hanoi University of Technology.

Page1 / 20

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

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online