Business Decision Making Assignment - Case Study - Management Assignment Help

Assignment Task:

Task:

In January 2019 Lee and Kelly set up a small limited liability company called Fambis Builders (FB). This business builds kit homes in New South Wales, around Canberra. (For those of you who do not know what kit homes are, see the appendix at the end of this document.) FB is slightly different to some kit home manufacturers, as this company manages the building process. The staff at FB will complete some of the work themselves and outsource other work to qualified professionals, who have an ongoing long-term professional relationship with Lee and Kelly.

Lee and Kelly contributed $1,000,000 cash to capitalize this business, using the proceeds from the sale of a previous business. In early January 2019 the company bought a factory in a rural area outside Canberra. The factory is built on land owned by the company. The land cost $100,000, the cost of constructing the factory was $500,000

Required

Prepare responses to the issues below. Some responses will require you to use Microsoft Excel, others will be completed using Microsoft Word. These are indicated below. Please note, heavy penalties will apply for inappropriate spreadsheet design. You will need to use named cells, linking, and formulas. Minimize the use of hard coded data in your models.

1) (Excel) name a sheet Data and place relevant inputs there. Name these inputs. You will use these named cells in formulas and models below. (5 marks)
2) Name a sheet Budget 2018. Build a model which will show the contribution margin of each model of kit home, assuming the frames are fabricated by FB at their factory. The column headings will be Model 1, Model 2, Model 3. (30 marks)

a. On the same sheet and under the contribution margin, list the annual budgeted fixed costs of the business. (5 marks)
b. Under the fixed costs, calculate the budgeted profit or loss the entity expects to make for 2018. You can assume that the company expects to sell 7 units of Model 1, 10 units of Model 2, and 3 units of Model 3 in 2019. (5 marks)
3) (Word document) identify limitations and weaknesses of the model you have created. (15 marks)

This Management Assignment has been solved by our Management  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics.Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.