MBA-AC721 Project Part 2 Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel workbook for BRBC Budgeted Income Statement and create the 2018 budget using the following information.

Budgeted Sales of Bike C: Online 75,000 bikes; instore 5,000 bikes. Bike C is purchased from Built-Right Bike Company, a sister company in the Biltmore Bicycle Corporation (BMBC), for $52 and is sold for $104.

Inventory: Beginning inventory: $ 52,000

Purchases 4,108,000

Sales ?

Ending Inventory $ 52,000

Employees:

Managerial Staff: Manager: 1 FTE, $45,000 annual salary plus 20% benefits

Bookkeeper: 1 FTE, $40,000 annual salary plus 20% benefits

Purchasing & Receiving Supervisor: 1 FTE, $35,000 annual salary plus 20% benefits Other staff: Warehouse: 2.5 FTEs make $15 per hour plus 17% benefits Online sales staff: 2 FTEs, $15 per hour plus 17% benefits (no commission)

NOTE: 1 FTE = 2080 hours

Store Hours: Monday – Saturday 10:00 am – 6:00 pm

2 sales clerks work from 10-3 M-F

3 sales clerks work from 3-6 M-F

4 sales clerks work 10-6 on Saturdays

Sales clerks earn $15 per hour plus 17% benefits Instore sales staff share commission equal to 10% of instore sales.

Budgeted Utility cost: $13,200

Budgeted Marketing Cost: $175,000

Contributions & community service: 10% of instore revenue

Other costs (includes depreciation, insurance, etc): $1,300,000

Income tax 29% of Net Revenue

• This Individual Case Study Assignment should be around 1,000 words in total and should be submitted in the form of a business report (approximately 500 words for each part).

Individual Case Study Assignment Part A

BLC Ltd. is a medium-sized UK manufacturing company based in Liverpool.

The company is seeking to expand its operations with the establishment of an office block to house the marketing and human resources staff in Manchester. The company has narrowed the choice to two alternatives with the following net cash flow information being available:

Items to keep in mind:

• The company’s current cost of capital is 10%.
• For this assignment, ignore taxation.

Required

As the company accountant is currently on holiday, you are required to:

• By calculating net present value, internal rate of return and payback, advise the company which option they should take.

• Critically evaluate the other qualitative factors that might be taken into account in this decision.

Individual Case Study Assignment Part B

BLC Ltd. has revenue of £500 million and sells all of its goods on credit to a variety of different wholesale customers. At the moment the company offers a standard credit period of 30 days. However, 70% of its customers (by revenue) take an average of 70 days to pay, while the other 30% of customers (by revenue) pay within 30 days. The company is considering offering a 2% discount for payment within 30 days and estimates that 80% of customers (by revenue) will take up this offer (including those that already pay within 30 days).

The Managing Director has asked the credit controller if the cost of this new policy would be worth offering. The company has a £80 million overdraft facility that it regularly uses to the full limit due to the lateness of payment and the cost of this overdraft facility is 15% per annum.

The credit controller also estimates that bad debt level of 2% of revenue would be halved to 1% of revenue as a result of this new policy.

Required

1. Calculate the approximate equivalent annual percentage cost of a discount of 2%, which reduces the time taken by credit customers to pay from 70 days to 30 days.
2. Calculate the value of trade receivables under the existing scheme and the proposed scheme at the year-end.
3. Evaluate the benefits and costs of the scheme and explain with reasons whether the company should go ahead and offer the discount. You should also consider other factors in this decision. (Hint: You need to work out the cost of the discount compared to the interest on the overdraft saved and bad debt reduction.)

Erin is a 19-year-old university student in her second year at university. Erin is bright and has always been a high achiever at school, and her parents have been keen to prompt her to follow her dreams and encourage her pursuits. Erin loves cooking for her family, particularly her older brother Josh. In order to achieve the best possible Year 12 score, Erin’s parents decided to move her to a private school for girls that had a good reputation for university acceptance. Erin’s mother took on extra work to pay for the school fees. While Erin was sad to leave her old school and friends, she agreed that this was the best choice for her academically. Things did not go as well as planned, however, and Erin was subjected to distressing bullying from the beginning of Year 12 until she finished the school year. Erin has always been conscious of her health and weight but was targeted because she had ‘fat legs’

and the bullies sent her text messages of ‘fat people’ and memes with derogatory messages about her. Because her parents had made sacrifices for her to attend this school, Erin didn’t want to tell them that she was being bullied, so she kept it to herself. This bullying had a devastating impact on Erin’s self-esteem, and she began dieting. People would comment on how great she looked, so she continued dieting. She felt she had some control over what she ate, and this made her feel better. When her local gym had a special rate for new members, Erin joined. When she wasn’t at the gym, she was studying. Because she was working out so much, and restricting her diet, Erin became seriously constipated. So, she went to her local pharmacy and began buying laxatives. Erin noticed that they helped with her constipation, but they also reduced her weight (Erin would weigh herself daily), so she began taking them all the time. It got to the point where her local pharmacy would not sell them to her anymore, so she began buying them from multiple pharmacies and online. Despite the turmoil at school, Erin did well academically and achieved exceptionally high marks in her final exams. She got her first preference for courses and enrolled in a Bachelor of Dietetics at a well-regarded university. Recently, however, wearing baggy clothing and restricting her food intake has been causing suspicions. Her mother has told her she is too thin, and her brother and father have expressed concern about her –but Erin doesn’t see it this way. When Erin looks in the mirror, she sees the fat girl who was bullied in Year 12. Erin has collapsed at her gym several times, and staff have expressed concern about her weight. Erin worried that as with the pharmacy, she will need to find another gym. At 1.62 cm tall and weighing 41 kg, Erin’s BMI is 15.6.

1. What are some of the physical risksassociated with Erin’s behaviours?
2. Erin is exhibiting many different behaviours consistent with ED. Describe what these are;
3. EDs can be upsetting for family and friends of the consumer, and family members who are concerned about their loved one are almost always correct in their ED concerns. What are the impacts on the familyare common when a member has an ED;
4. Investigate longer term issues that may impact recoveryfrom an Eating Disorder.
5. Develop three questionsyou would ask Erin during an interview to complete an MSE. They could be from any MSE area.
6. Complete a risk assessment;
7. Develop a nursing care plan.

Imaginary story
You have just been appointed as the Finance Director for South East Asia of a large multinational bank (the Bank of Northeastern States), based in the United States and headquartered in Boston, Massachusetts. You have been posted to a recent acquisition of a Stock Market listed manufacturing plant, Peninsula Transport located in a small township some 40 kilometres outside the capital city of Indonesia. Your instructions are to asset strip the acquired company then close it down within one year.
Two weeks into your appointment and having just arrived in Jakarta you are given a company provided apartment and have spent several days unpacking and settling in with your family. Today is your first day at work and Mr Mohamed, the incumbent CEO a man who has inherited the company from his father informs you that he knows exactly why you are in Indonesia and begs you not to close his company. As the day progresses, you begin to realise that before the $ 100 million acquisition, the factory had been a wholly owned family business that had served the community for more than four decades and employed just under half the town’s available workforce of three thousand people. Indeed, there were many families, some with three generations in current employment with the company. In addition, you also realise that many small and medium local enterprises support the factory and that to close it will devastate the entire community. The CEO claims that he and his family are victims of a conspiracy to close the factory and sell the land to build real estate on it. He shows you a newspaper report from several years ago that clearly depicts the land surrounding the town being earmarked for development under the government’s plans for the future of the area. This involves building several thousand residential units and expanding the township into a commuter suburb serving the capital city.
Mr Mohamed informs you that he has rejected several offers from the government and has successfully fought them in the courts and obtained ‘heritage status’protection to overturn a local government order for compulsory purchase of the land from his family who have owned it for several generations.
The local CEO also informs you that he has evidence of bribes and gifts being made by the Bank of Northeastern States to local politicians, as well as substantial donations to National People’s Party, a political party who are the incumbent government. It is very clear that there is a trail of corruption leading all the way back to your employers in Boston. That night you call your CEO at Northeastern Bank to inform him and are shocked when he responds with threats against you and your family that if you don’t do as instructed you will be arrested and thrown in jail by local police. The next morning before you leave for work, you are paid a clandestine visit by a senior police officer and he also informs you in a veiled threat that your situation in Indonesia leaves you and your family very vulnerable. At this point, you realise that you have been lied to by the Board of Northeastern States Bank and that they are partners in a web of corruption worth tens of millions of US Dollars involving local Indonesian politicians and local police.
You find yourself in a dilemma. If you follow through with your instructions you understand that you will be responsible for the social consequences of closing the factory and will be just as guilty as those who are involved in the conspiracy. If you don’t you will be fired and face an uncertain future in which you and your family, having already been threatened, leaves you in no doubt of the consequences of being arrested and detained in a foreign country where you have no rights.

Two questions to discuss:
1) What should you do?
2) Why would you do that?

1.What are the 12 key requirements for documenting and reporting individual service planning and delivery?

2What are the three types of resources you may require when facilitating service planning? Provide an example of each type of resources

3.

Conduct a risk management assessment for Allan remaining at home (include at least one environmental, physical and emotional risk each). The template to conduct this assessment is on the next page.

Assume that Trump is re-elected President. Analyze the impact of this event on the China-US trade dispute. Your answer will have two parts a) Discuss the method/framework that you are using to perform the analysis. b) Using the method that you described above, quantify the impact on China’s exports and imports from the US.Assume that Biden is elected President. Analyze the impact of this event on China-US trade dispute. Your answer will have two parts a) Discuss the method/framework that you are using to perform the analysis. b) Using the method that you described above, quantify the impact on China’s exports and imports from the US

agree or not?

Workforces in many nations are changing due to changes in birth and mortality rates, immigration, age distributions, external pressures, and competition. Question: What is the significance of diversity issues on the nation’s growth, and how do they affect the workforce of a nation? In the U.S., how have these changes altered the national workforce? Has the focus on diversity improved or injured the national culture? Is diversity, as a construct in itself, always positive? What other factor (s) may be necessary to make diversity successful?

The significance of diversity in the workplace is the creativity, innovation, and productivity. Having a diverse workforce creates a positive environment where employees feel included. Diversity in the United States brings ideas, processes and other positive attributes that allow the US to flourish and become the greatest country in the world.

Diversity in organizations is an aspect of societal changes and is increased or impeded by individual, organizational, and societal factors. Question: How can organizations manage diversity on a long-term basis? It is important for organizations to have processes and plans in place to recruit diverse employees. There needs to be diversity training for the leaders of the company and activities that allow employees to highlight their culture, like international potlucks. In this week's Ted Talk, what actions does the speaker describe that will decrease stereotypes?

In this week’s Ted Talk, the speaker mentions having a diverse group of friends and getting to know them and their culture. We must learn to appreciate differences in people and embrace cultural differences.

What key takeaways, from this course, will you apply in the workplace?

This class came at a perfect time in my career. As an HR Business Partner and recruiter, it is important for me to bring people in that have diverse backgrounds. In order for a company to succeed long-term, employees need to be creative and innovative and this is easier when the employees have different backgrounds.

Vogl Company is a U.S. firm conducting a financial plan for the next year. It has no foreign subsidiaries, but more than half of its sales are from exports. Its foreign cash inflows to be received from exporting and cash outflows to be paid for imported supplies over the next year are shown in the following table:

The spot rates and one-year forward rates for these currencies as of today are as follows:

Based on the information provided, determine the net exposure of each foreign currency in US dollars. 8 Marks

Given the forecast of the Canadian dollar along with the forward rate of the Canadian dollar, what is the expected increase or decrease in US dollar cash flows that would result from hedging the net cash flows in Canadian dollars one year forward? Would you hedge the Canadian dollar position? Why?

      5 Marks

Given the forecast of the Singapore dollar along with the forward rate of the Singapore dollar, what is the expected increase or decrease in US dollar cash flows that would result from hedging the net cash flows in Singapore dollars one year forward? Would you hedge the Singapore dollar position? Why?

June is a cash basis taxpayer and a fashion and makeup consultant in a high fashion company, Goldielocks, Inc. She earned a salary of $60,000. She also was provided a disability income protection policy for which Goldielocks Inc. paid a %1,500 premium for June's insurance. The company also provided health insurance for her which cost the company $15,000 and long term care insurance for her which cost the company $1,000 premium.

Her salary would have been $65,000 but she was paying off her student loan at $5,000/year and Goldielocks agreed to reduce her salary by $5000 and pay her loan on her behalf. The long term care insurance was provided for all the employees as well as all the other insurances. while her salary was $6,000, Goldielocks had a 401(k) plan and June voluntarily put $3,000 of her $60,000 salary, 5% of it into her 401 (k). Her employer matches that with $3000 contribution.

What is June's taxable income from Goldielocks this year?