Question
WorldExplorer is a car manufacturer manufactures small sized cars. Their accountant have collected the cost data for the past 4 months in 2017. All the
WorldExplorer is a car manufacturer manufactures small sized cars. Their accountant have collected the cost data for the past 4 months in 2017. All the employees, except supervisors and admin staff, working on their production line is paid by number of working hours. According to the industry agreement with the union, there would be an increase on supervisor's salary in Dec 2017. Their delivery company-Punctual charged them a base rate and car handling cost for each car they delivered. The rental cost would also increase in Dec 2017. All cost changes h?appened in Dec 2017 will stay effective in the future.
4-1 The accountant of WorldExplorer also prepared a budget (displayed below) for the company for its operation from Jan 2018 to April 2018. The accountant advises you following points: * Unit cost remain unchanged * Manufacturing fixed and variable overhead costs are allocated based on number of production *The company keeps 5% of each month's projected sales volume as the ending inventory 4-2 WorldExplorer's accountant noticed every month 50% cars are purchased by cash and another 50% is credit sale. Money for credit sales is collected in the following pattern. 60% of the credit sales amount will be collected in the month of sale, 39% will be collected in the following month and 1% is uncollectable. On the 1st of Jan, account receivable from Dec's sale is 4000000. Using the information given, answer the following questions. Show your calculations....
1. what is the cost function for WorldExplorer? (3 marks)
2. If they would manufacture 2200 cars in Jan 2018, what is the total cost? (1.5 marks)
3. Prepare Cost of Goods Sold Budget for Feb 2018 (3.5 Marks)
4. Prepare Cash receipts (inflow) budget for each month in the first quarter. (4 Marks)
Sep Oct Nov Dec Number of Cars Manufactured Raw Material Cost Administrition & Sales Direct Labor cost Supervisor Salary Product delivery Rent 2,000 13,440,000 12,960,000 12,000,000 9,600,000 310,000 8,960,0008,640,000 8,000,000 6,400,000 22,000 320,000 250,000 2,800 2,700 2,500 314,000 313,500 302,500 20,000 328,000 200,000 20,000 327,000 200,000 20,000 315,000 200,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started