University | Singapore University of Social Science (SUSS) |
Subject | BUS100 Business Skills and Management |
BUS100 Business Skills and Management Assignment, SUSS, Singapore: Mindy operates a company called “Fruity Juice” via e-commerce website It sells apple juice, orange juice and guava juice in boxes
Question 1
Mindy operates a company called “Fruity Juice” via e-commerce website. It sells apple juice, orange juice and guava juice in boxes. She rents a warehouse to store these items and engages a third-party logistics vendors to ship these items to the customer. The cost of goods sold (COGS), selling price and daily demand for each item is given in the table below:
The warehouse rental is $8000 per month. Mindy has hired 3 staff to help her with the operation and each staff cost $3000 per month and she gets a salary of $5000. To promote the product online, Mindy also spends $2000 monthly on digital marketing to increase her brand awareness. She also needs to pay third-party logistics vendors $0.50 per 10 boxes to ship the items to the customers.
Assuming that there are 30 days in a month.
a. Construct a spreadsheet model to analyze the company’s monthly finance, the spreadsheet model should include total revenue ($), total expenses ($), profit/loss ($) and profit margin (%). Sketch the influence diagram of your model.
b. If the company wants to increase the profit margin to 10% by changing the selling price of Apple Juice, discuss what will be the new selling price of apple juice, explain how you derive the answer? Show your answer in nearest 10 cents.
c. For every $1 increase in price, the demand will drop by 20 boxes. It applies to all the juices. What is the relationship between the selling price and the demand for all juice? Calculate the demand for apple, orange and guava juice if the selling price is $16 per unit?
d. What will be the new selling price for all juices, if the company wants to earn 20% profit margin, your model should include the price elasticity of demand. Total demand for each month has to be at least 15,000. Describe how you derive at the solution (write down the steps in detail) and clearly show the new profit margin and selling price.
Buy Custom Answer of This Assessment & Raise Your Grades
Question 2
You are planning your finance for the next twenty year. Assume that you will earn a constant interest rate on your money. At the beginning of the first year, you have $15,000 in your bank account. Your salary is $45000 in the first year and it is expected to grow at 3% per annum.
Your expenses is $25000 and it is expected to grow at 5% each year. You will deposit the remaining amount to a fixed deposit account at the end of each year and it will earn an interest of 7% per year.
a. Develop a spreadsheet model that will show you how much you will have accumulated at the end of 20 years. Use your worksheet to compute the amount of money and interest earned at the end of 20 years for the inputs given here and tabulate your results.
What is the average deposit and bank balance? You should have a separate column for income, expenses, annual deposit and interest earn for each year. You should also show the finance using appropriate graph. (16 marks)
b. Identify what will be the interest rate the bank should pay, so that you have exactly $1,000,000 in 20 years? How much is the total interest earned? Explain how you derive
the answer.
c. You reckon that you may need to withdraw $25,000 from the bank at the start of the tenth year for your kid’s education for four years (year 10th – 13th) and the tuition fees is expected to increase by 10% each years. For an interest rate of 7% per year as given in part a), analyse what would be your bank balance at the end of 20 years and total withdrawal amount. You may add a new column for Withdrawal to take care of the withdrawal amount.
d. State two ways how you can grow your bank balance at the end of 20 years.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Question 3
Based on your experiences of running a virtual company in MonsoonSIM or working in a company,
(a) Explain two ways how you can increase the cash flow for your company by analyzing some key performance indicators such as sale volume, COGS and production.
(b) You may refer to the virtual company in MonsoonSIM or any company that you have worked for as reference, describe three ways how the company can increase the market shares and gives a detailed explanation of your recommendations.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Singapore students at Singapore University of Social Science (SUSS), listen up! Struggling with your BUS100 Business Skills and Management assignment? Look no further! Our assignment writing service Singapore is here to provide the solution you need. Pay our experts to receive comprehensive assistance with both formative and summative assignments. We specialize in case study writing help and can guide you through the intricacies of managing Mindy's company, "Fruity Juice."
Tags:-
- Business Accounting & Finance – (VM) – A3 Assignment, UOM, Singapore
- HRM3010S: Managing People At Work, Assignment, UCD, Singapore
- HFS351: Safety Management and Audit, End-of-Course Assessment, SUSS, Singapore
- HFSY217: Emergency Preparedness and Response Planning, TMA (Tutor-Marked Assignment), SUSS
- CMM315: TMA (Tutor-Marked Assignment) – Peacebuilding and Security, SUSS, Singapore
- Harley Davidson utilized different entry mode strategies in pursuit of internationalization: Sustainable, Assignment, UoN, Singapore
- Nursing Patients With Chronic Illness, Assignment 3, LTU, Singapore: Jason Bundhoo is a 42-year-old car driver from Triolet
- DSM: R for Data Science, Coursework 2, UOL, Singapore: In this coursework assignment you should return to this dataset and perform an appropriate investigation into building a statistical model
- DSM120: Financial Data Modelling, Coursework 1, UOL, Singapore
- Data Science Final Project, Coursework 1, UOL, Singapore: Your first formal coursework submission is your full project proposal, This sets out very clearly what your Data Science Project will be, and also how you will conduct the project
UP TO 15 % DISCOUNT