BUS100 Tutor-Marked Assignment January 2025 SUSS : Business Skills And Management

This assignment is worth 40% of the final mark for BUS100 Business Skills and Management.
The cut-off date for this assignment is 21 February 2025, 2355hrs.
Note to Students:
Compose your report using Microsoft Office Excel, and save it either as .xls or .xlsx (preferred).
You are to include the following particulars in your submission: Course Code, Title of the TMA, SUSS PI No., Your Name, and Submission Date.
Read the following Case Study. Create appropriate Excel models to analyse it. You need to have your models in an appropriate xlsx Excel file. You should only submit one workbook for this TMA. It is individual assignment and there is a severe penalty to refer to other work.
All questions will need to be answered in your Excel file. The answer for each question must be in its own worksheet. Organise your workbook with worksheets as follows: Cover, Q1, Q2, and Q3. The Cover worksheet should contain your Name, PI Number, Seminar Group, Assessment Name and Module Code.
Each model should fit into one worksheet (A4 page), with user-friendly formatting and layout, clear documentation and print-ready state. You must provide answers to the individual questions posed in the problems.
Note that for take-home assignment, students are expected to research beyond the school textbook and course materials.
Refer Sample TMA and Sample TMA solutions as your guide to the standard expected. See also the rubric below given for grading each problem.

For your submission, you will need to upload a single Excel workbook (xlsx) file for grading via Canvas. Please remove any VBA or Macro from your workbook.

Use of Generative AI Tools (Allowed)
The use of generative AI tools is allowed for this assignment.
• You are expected to provide proper attribution if you use generative AI tools while completing the assignment, including appropriate and discipline-specific citation, a table detailing the name of the AI tool used, the approach to using the tool (e.g. what prompts were used), the full output provided by the tool, and which part of the output was adapted for the assignment;
• To take note of section 3, paragraph 3.2 and section 5.2, paragraph 2A.1 (Viva Voce) of the Student Handbook;
• The University has the right to exercise the viva voce option to determine the authorship of a student’s submission should there be reasonable grounds to suspect that the submission may not be fully the student’s own work.
• For more details on academic integrity and guidance on responsible use of generative  AI tools in assignments, please refer to the TLC website for more details;
• The University will continue to review the use of generative AI tools based on feedback and in light of developments in AI and related technologies.
Important Note: Grading of TMA Submissions
Marks awarded to your assignment are based on the following guidelines:
1. 80% of the marks are allocated to the content of your answers:
➢ The marks awarded to what your answers cover depend on the extent to which they cover the key points that correctly and comprehensively address each question.
➢ The key points should be supported by evidence drawn from course materials and, wherever relevant, from other credible sources.
2. 20% of the marks are allocated to the presentation of your answers:
Wherever applicable, the marks awarded to how your answers are presented depend on the extent to which your answers:
➢ form a sound reasoning by developing those key points in a clear, logical and succinct manner;
➢ provide proper and adequate in-text citations and referencing to content drawn from course materials and other credible sources;
➢ strictly follow APA formatting and style guidelines1
, in particular for:
• in-text citations and end-of-report references;
• the identification of figures and tables;
➢ use, wherever relevant, the specialised vocabulary and terminology commonly used in discussions about the topic(s) covered by each question;
➢ provide a reference or bibliography at the end of the main report;
➢ include the less relevant details in an Appendix;
➢ use sentence constructions that are grammatically and syntactically correct;
➢ are free from spelling mistakes; present the workings, numerical formulations and results in a logical manner that follows the APA formatting and style guidelines;
➢ design and present graphs, diagrams and plots that follow the APA formatting and style guidelines;
➢ are highly original;
➢ have proper formatting, which may:
• include a properly formatted cover page;
• respect the answer length/word count set out in the assignment guidelines, if
any is prescribed;
• present answers in paragraphs with proper spacing and page margins;
• include page numbers and appendices, if necessary.
You can find a short tutorial on the APA formatting and style guidelines here: https://apastyle.apa.org/index.
Additional details (pertaining to tables and figures) can be found here: https://is.gd/O4vDdT.

Question 1 (40 marks)

Most retail shops have closed their physical stores and set up websites to sell their goods online. The advantage of online shopping is that there is no retail space rental, which is quite expensive in Singapore, where land is scarce. E-commerce firms are thriving around the world. Ecommerce revenue reached 5.8 trillion US dollars in 2023. Tim is a recent university graduate who has started his own business selling cosmetics online.
Since the launch of the new online website “BeautyMe” last year, the number of visitors to his website is 500,000 (half a million visitors), denoted as year 1, and expected to grow at 1.5% per year. Among the visitors, 2% of the visitors will place at least one order. The average sale amount is $35 per visitor. The cost of goods sold (COGS) is 40% of the revenue. Tim will rent the space to store his cosmetics each year, costing him $10,000. The rental will grow by 5% each year. The manpower cost is $60,000 yearly, which is expected to increase by 3% yearly.
(a) Construct a spreadsheet model of the website’s visits and sales for the next ten years (years 1 to 10). Identify the total expenses, such as COGS, rental, and manpower costs, as a percentage of the overall cost for ten years. (11 marks)
(b) Compute the total revenue, accumulated profit, and profit margin (%) at the end of 10 years. Draw an appropriate graph to show the company’s finances for ten years.
                                                                                                                                                (7 marks)
(c) What should the visitor growth rate per year be if the shop owner wants $2,000,000 (Two million) in total profit at the end of 10 years? Explain how you derive the
solution.
(5 marks)
(d) Tim has a $60,000 budget to buy cosmetics and sells four products. The table below shows the cost and selling price for each product. Based on his experience, he wanted to buy at least 100 quantities of each product, and each product’s cost should not be more than 30% of the overall cost.
Product Unit cost ($) Selling price ($)
Facial care 50 80
Makeup 100 150
Lip care 30 45
Shampoo 20 30
Develop a model to help him determine the quantity of each product he should purchase for his shop to maximise his profit. Present the constraints and decision variables. If he wants to maximise the total quantity purchased, how will the number of quantities to buy for each product change? (12 marks)
(Hint: Select GRN Nonlinear Solving Method.)
Presentation
Your models for Q1 must be neatly laid out and presented. You must apply appropriate colours, alignment, labels and formatting of numbers. Documentation is required.
(5 marks)

Question 2 (40 marks)

Simon plans to retire at the end of twenty years. His annual salary is $56,000 now and is expected to grow at 3%. His expenses will be $25,000 yearly and are expected to grow at 4% yearly. He will save the remaining money in the bank account at the end of each year and will only earn interest at the end of the next year. He currently has $70,000 in his bank account at the beginning of year 1, and he will earn an interest rate of 3.5% annually. Assume he will earn a constant interest rate based on the bank interest rate.
(a) Solve Simon’s twenty-year retirement plan by developing a Spreadsheet model. Each year, you should have a row showing his finances, such as deposits, withdrawals, interest earned and total end balance at the bank. You may add more columns as you require; you need to ensure that the formulas can be filled down the rows for each column. Calculate the total balance in the bank account at the end of 20 years.
Use your worksheet to compute the total amount of money he will have at the end of 20 years for the inputs below and tabulate your results:
(i) a salary growth rate of 5%, an expense growth rate of 3% and an interest rate of 4.5% per year,
(ii) a salary growth rate of 2%, an expense growth rate of 8% and an interest rate of 6% per year,
(14 marks)
Use your worksheet to answer the questions below:
(b) How much should the salary growth rate be yearly to have exactly $1,500,000 in 20 years, assuming he earns 3.5% interest annually and the expense growth rate is 4%? Explain how you get the answer. Show your answer in two decimal places.
(7 marks)

Parts (c) and (d) are independent of parts (a) and (b).
(c) With an initial bank balance of $70,000 at year 1, Simon wants to withdraw $15,000 from the bank at the start of the fifth, tenth, and fifteenth years for a good holiday with his wife. For a deposit of $30,000 at the end of each year and an interest rate of 7% per year, determine his bank balance at the end of 20 years.
(7 marks)
(d) Instead of saving the money in the bank, Simon’s friend asked him to invest in his business adventure. Simon needs to invest $150,000 initially, and his friend will give him $20,000 in the first year, an increase of $2000 from the previous years for the next nine years, and an end-of-term bonus of $5000 in the tenth year. Using the discount rate of 8% and the bank interest rate of 4%, would you recommend Simon to save his money in the bank or invest in his friend’s business adventure? Justify your answer using the model.
(7 marks) 
Presentation
Your models for Q2 must be neatly laid out and presented. You must apply appropriate colours, alignment, labels and formatting of numbers. Documentation is required.
(5 marks)

Question 3 (20 marks)

Using your experience of running a virtual company in MonsoonSIM,
(a) Describe three ways you can increase her revenue through retail, B2B, and e-commerce by analysing some key performance indicators such as sale volume, production, and market share.
(Limit your answer to 300 words).
                                                                                                                                                (10 marks)
(b) You may refer to the virtual company in MonsoonSIM or any company that you have worked for as a reference. Discuss how the organization can use data analysis to improve inventory management and give a detailed explanation of your recommendations.
(Limit your answer to 300 words).
                                                                                                                                                (10 marks)

The post BUS100 Tutor-Marked Assignment January 2025 SUSS : Business Skills And Management appeared first on Singapore Assignment Help.