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 happened in Dec 2017 will stay effective in the future.
4-1 The accountant of WorldExplorer also prepared a budget (displayed below) forthe 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)
Unit coSt Manufacturing fixed and variable overhe allocated based on number of production "The company keeps 5% of each month's projected sales volume as the ending inventory ad cUSIS Feb March April Jan 1,700 2,00 2,00 Projected sales 2,100 15,00014,000 13,000 13,000 Selling Price Required production Direct Material Cost Direct labor cost Fixed and Variable Manufacturing Overhead 2,120 9,540,000 6,572,000 25440 WorldExplorer's accountant noticed every month 50% cars are purchased by cash and another 50% is credit sale. Money for crodit Unit coSt Manufacturing fixed and variable overhe allocated based on number of production "The company keeps 5% of each month's projected sales volume as the ending inventory ad cUSIS Feb March April Jan 1,700 2,00 2,00 Projected sales 2,100 15,00014,000 13,000 13,000 Selling Price Required production Direct Material Cost Direct labor cost Fixed and Variable Manufacturing Overhead 2,120 9,540,000 6,572,000 25440 WorldExplorer's accountant noticed every month 50% cars are purchased by cash and another 50% is credit sale. Money for croditStep 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