URGENT! UPDATED! Hello experts, someone please help me solve this Assignment for my final exam. It is related to Budgeting and Management Reporting. First, I am going to upload 6 pictures of the question, broken down into screenshots. The other 4 pictures "template" is the Excel table/template needed to solve the question which hopefully makes it easier for the tutors. I cannot upload Excel file here, does not allow me to. The deadline is tomorrow and I would highly appreciate if someone can help me out ASAP with the correct method!

Transcribed Image Text:

Budgeting and Management Reporting 2022 Final assignment Below please find information about the final assignment for the course. The assignment is to be handed in as one Excel spreadsheet and one pdf document through itslearning, by the deadline 17.3.2022. 1. Background You have been employed as financial controller from 1.12.2021 of a small family-owned company. In the past there has really been no financial management but now that the founder's daughter took over as CEO she wants proper procedures and reports. The company has a board of directors with three external board members plus two representatives of the owning family. The company imports electronic equipment from South Korea and Japan and sells that to distributors. There are no retail sales of the products directly to customers, but there is a service department selling spare parts online to consumers and repair shops. The company is organized into three divisions: Audio (2 salespersons), Video (1 salesperson) and Spares (1 salesperson). The purchasing is done by one person and you are in administration. The CEO is also a full-time employee. Budgeting and Management Reporting 2022 Final assignment Below please find information about the final assignment for the course. The assignment is to be handed in as one Excel spreadsheet and one pdf document through itslearning, by the deadline 17.3.2022. 1. Background You have been employed as financial controller from 1.12.2021 of a small family-owned company. In the past there has really been no financial management but now that the founder's daughter took over as CEO she wants proper procedures and reports. The company has a board of directors with three external board members plus two representatives of the owning family. The company imports electronic equipment from South Korea and Japan and sells that to distributors. There are no retail sales of the products directly to customers, but there is a service department selling spare parts online to consumers and repair shops. The company is organized into three divisions: Audio (2 salespersons), Video (1 salesperson) and Spares (1 salesperson). The purchasing is done by one person and you are in administration. The CEO is also a full-time employee.