Please help!

The date is October 1, 2021. Your friend, Jeremy LeBail, owns a small business that makes novelty birthday cakes, sold over the internet and delivered by courier. Since demand has grown rapidly he is worried that he will not be able to obtain enough, fully trained, staff to meet his current forecast for 2022. Following your advice, he has prepared a forecast of the maximum sales achievable for each cake model in 2022, and associated costs, as below: Cake Rocket Princess Laptop Total (5000) (5000) (5000) (5000) Factor Variable Costs: Materials 12 8 10 30 Labour 18 12 24 54 6 4 4 14 Other Expenses Allocated Fixed Cost 12 30 24 66 Total Cost 48 54 62 164 Sales Revenue 78 58 66 202 Profit 30 38 However, the amount of labour he expects to have available is limited to $40,000-hence his dilemma; note that all variable labour is paid at the same hourly rate. 1. Based on the information above you are required to prepare a financial analysis presented as a table; this should then be saved as a picture (no larger than 10x10 cm) in either jpg, jpeg or png format only, with a clear, explanatory title. The table should present details for each cake model to show how the restricted amount of labour available ($40,000) should be allocated to them to maximise his profit under the constraints. Jeremy has explained that sales for each of the three cake models in that analysis should be a minimum of at least half of the above forecast. In addition, you should prepare a text document of no more than 250 words that will explain your approach to the analysis, and also give suggestions to Jeremy as to other ways by which profitability might be improved, given the labour shortage. The text document should not include any italics, underlining or bold. You should include your student number as a separate line at the end of the text, but no further details are needed. 2. When you have completed your analysis you should press the Upload button for the assignment and copy the contents of your text document into the box marked "Text" (excluding your student number). Then upload your table file to the "Attachments" section. 3. After uploading you should now see that a new discussion thread for the interim assignment has opened. If you are the first to upload the submission you will only see your own entry, but if you are not the first you will also see the postings from the other students. 4. Once several students have posted their analysis, but no later than seven days after the end of Unit 3, you are required, in the new Forum thread, to critique (with both positive and negative comments, supported with evidence as appropriate) the submissions of other students, both in terms of the contents of their submissions, and supporting comments, as well as the presentation style itself. Your postings should not exceed a total of 250 words and should cover no more than the submissions of three other students. 5. If you cite external sources then you should use the Harvard referencing system. 6. General feedback will be posted in the Forum by the end of Unit 4, and through your home page you will receive an indication of your performance, using the rubric on the following page. Feedback to Student Exceeds Meets expectations expectations (60-69%) (40-59%) Passing Grades Participates Participation Student's Student engages consistently (level of engagement) seeks and exploits every presence demonstrates opportunity for interaction in the forum through prolific follow-on eagerness to participate and support collective learning. Student demonstrates leadership in the discussions with colleagues in various discussion threads on a regular basis and in a meaningful manner. contributions. Student demonstrates leadership in the discussions Contributes Collaborates towards the collective generation of higher learning Inferences substantial viewpoints in discussions with the aim to explore meanings and identify hidden values Contributions advance discussions by challenging class with well- substantiated viewpoints. Contributions are well positioned in the realm of unit's theme and well integrated with ongoing discussions. Demonstrates Very good Satisfactory a good understanding of subject. Theories that span module knowledge and uses theory to inform arguments Excellent understanding of understanding of understanding of subject. Contributions add new meaning in theoretical discoveries and help the class widen its horizons subject. Contributions are built upon appropriate theoretical perspectives. boundaries are used to offer insightful reflections. Writing meets the standards of graduate studies (language clarity. organization, citing and referencing. Excellent writing standards are demonstrated Postings are written in clear, Writing offers an academic reading where meanings are conveyed clearly and meaningfully. Harvard Referencing Work unfolds coherently and smoothly using an organized approach Le sections are used, appropriate concise, technically correct English suitable for System is headings are etc.) academic correctly applied. audiences chosen, etc. Harvard Referencing Harvard Referencing System is System is correctly applied. correctly applied. Overall grade: -Unsatisfactory -Improvement needed: -Meets expectations: -Exceeds expectations: -Exceptional: Exceptional (70-100%) 0-29% 30-39% 40-59% 60-69% 70-100% Improvement Unsatisfactory needed (30-39%) (0-29%) Participation does not comply with SA Only few largely ad hoc contributions are made Contributions only minimally promote dialogue. requirements. Dialogue is not enhanced, there is no or minimal contribution to the development of knowledge in the classroom Contributions do Initial not reinforce unit's concepts and ideas and remain disconnected from ongoing discussions Understanding of contribution is poor and there are no follow on contributions basics of subject. Theory is only sporadically deployed, while not always used meaningfully Limited understanding of subject. No theory is used in initial and/or follow on contributions Writing uses correct language but meanings are not conveyed clearly. Work should become more coherent. There are several Writing is sloppy. disconnected and exhibits strong expression difficulties Harvard Referencing System is used wrongly. mistakes in the application of Harvard Referencing System Falling Grades... The date is October 1, 2021. Your friend, Jeremy LeBail, owns a small business that makes novelty birthday cakes, sold over the internet and delivered by courier. Since demand has grown rapidly he is worried that he will not be able to obtain enough, fully trained, staff to meet his current forecast for 2022. Following your advice, he has prepared a forecast of the maximum sales achievable for each cake model in 2022, and associated costs, as below: Cake Rocket Princess Laptop Total (5000) (5000) (5000) (5000) Factor Variable Costs: Materials 12 8 10 30 Labour 18 12 24 54 6 4 4 14 Other Expenses Allocated Fixed Cost 12 30 24 66 Total Cost 48 54 62 164 Sales Revenue 78 58 66 202 Profit 30 38 However, the amount of labour he expects to have available is limited to $40,000-hence his dilemma; note that all variable labour is paid at the same hourly rate. 1. Based on the information above you are required to prepare a financial analysis presented as a table; this should then be saved as a picture (no larger than 10x10 cm) in either jpg, jpeg or png format only, with a clear, explanatory title. The table should present details for each cake model to show how the restricted amount of labour available ($40,000) should be allocated to them to maximise his profit under the constraints. Jeremy has explained that sales for each of the three cake models in that analysis should be a minimum of at least half of the above forecast. In addition, you should prepare a text document of no more than 250 words that will explain your approach to the analysis, and also give suggestions to Jeremy as to other ways by which profitability might be improved, given the labour shortage. The text document should not include any italics, underlining or bold. You should include your student number as a separate line at the end of the text, but no further details are needed. 2. When you have completed your analysis you should press the Upload button for the assignment and copy the contents of your text document into the box marked "Text" (excluding your student number). Then upload your table file to the "Attachments" section. 3. After uploading you should now see that a new discussion thread for the interim assignment has opened. If you are the first to upload the submission you will only see your own entry, but if you are not the first you will also see the postings from the other students. 4. Once several students have posted their analysis, but no later than seven days after the end of Unit 3, you are required, in the new Forum thread, to critique (with both positive and negative comments, supported with evidence as appropriate) the submissions of other students, both in terms of the contents of their submissions, and supporting comments, as well as the presentation style itself. Your postings should not exceed a total of 250 words and should cover no more than the submissions of three other students. 5. If you cite external sources then you should use the Harvard referencing system. 6. General feedback will be posted in the Forum by the end of Unit 4, and through your home page you will receive an indication of your performance, using the rubric on the following page. Feedback to Student Exceeds Meets expectations expectations (60-69%) (40-59%) Passing Grades Participates Participation Student's Student engages consistently (level of engagement) seeks and exploits every presence demonstrates opportunity for interaction in the forum through prolific follow-on eagerness to participate and support collective learning. Student demonstrates leadership in the discussions with colleagues in various discussion threads on a regular basis and in a meaningful manner. contributions. Student demonstrates leadership in the discussions Contributes Collaborates towards the collective generation of higher learning Inferences substantial viewpoints in discussions with the aim to explore meanings and identify hidden values Contributions advance discussions by challenging class with well- substantiated viewpoints. Contributions are well positioned in the realm of unit's theme and well integrated with ongoing discussions. Demonstrates Very good Satisfactory a good understanding of subject. Theories that span module knowledge and uses theory to inform arguments Excellent understanding of understanding of understanding of subject. Contributions add new meaning in theoretical discoveries and help the class widen its horizons subject. Contributions are built upon appropriate theoretical perspectives. boundaries are used to offer insightful reflections. Writing meets the standards of graduate studies (language clarity. organization, citing and referencing. Excellent writing standards are demonstrated Postings are written in clear, Writing offers an academic reading where meanings are conveyed clearly and meaningfully. Harvard Referencing Work unfolds coherently and smoothly using an organized approach Le sections are used, appropriate concise, technically correct English suitable for System is headings are etc.) academic correctly applied. audiences chosen, etc. Harvard Referencing Harvard Referencing System is System is correctly applied. correctly applied. Overall grade: -Unsatisfactory -Improvement needed: -Meets expectations: -Exceeds expectations: -Exceptional: Exceptional (70-100%) 0-29% 30-39% 40-59% 60-69% 70-100% Improvement Unsatisfactory needed (30-39%) (0-29%) Participation does not comply with SA Only few largely ad hoc contributions are made Contributions only minimally promote dialogue. requirements. Dialogue is not enhanced, there is no or minimal contribution to the development of knowledge in the classroom Contributions do Initial not reinforce unit's concepts and ideas and remain disconnected from ongoing discussions Understanding of contribution is poor and there are no follow on contributions basics of subject. Theory is only sporadically deployed, while not always used meaningfully Limited understanding of subject. No theory is used in initial and/or follow on contributions Writing uses correct language but meanings are not conveyed clearly. Work should become more coherent. There are several Writing is sloppy. disconnected and exhibits strong expression difficulties Harvard Referencing System is used wrongly. mistakes in the application of Harvard Referencing System Falling Grades