ACCT 2210 Fall 2020 Project 1: Missing Data Hector P. Wastrel, a careless employee, left some combustible materials near an open flame in Salter Companys plant. The resulting explosion and fire destroyed the entire plant and administrative office. Justin Quick, the companys controller, and Constance Trueheart, the operations manager, were able to save only a few bits of information as they escaped from the roaring blaze. What a disaster, cried Justin. And the worst part is that we have no records to use in filing an insurance claim. I know, replied Constance. I was in the plant when the explosion occurred, and I managed to grab only this brief summary sheet that contains information on one or two of our costs. It says that our direct labor cost this year totaled $180,000 and that we purchased $290,000 in raw materials. But Im afraid that doesnt help much; the rest of our records are just ashes. Well, not completely, said Justin. I was working on the year-to-date income statement when the explosion knocked me out of my chair. I instinctively held onto the page I was working on, and from what I can make our, our sales to date this year totaled $1,200,000 and our gross margin was 50% of sales. Also, I can see that our goods available for sale to consumers totaled $810,000 at cost. Maybe were not so bad off after all, exclaimed Constance. My sheet says that prime cost totaled $410,000 so far this year and that manufacturing overhead is 80% of conversion cost. Now if we just had some information on our beginning inventories. Hey, look at this, cried Justin. Its a copy of last years annual report, and it shows what our inventories were when this year started. Lets see, raw materials were $18,000, work in process was $65,000 and finished goods were $45,000. Super, yelled Constance. Lets go to work. To file an insurance claim, the company must determine the amount of cost in its inventories as of the date of the fire. You may assume that all materials used in production during the year were direct materials. Required: 1. Determine the amount of cost in the Raw Materials inventory account as of the date of the fire. 2. Determine the amount of cost in the Work in Process inventory account as of the date of the fire. 3. Determine the amount of cost in the Finished Goods inventory account as of the date of the fire. 4. How much is the value of loss this company should file a claim to its insurance company for? 5. Can you give any suggestions to this company in accounting records backup and storage? Grading Rubrics 1. Deadline and format: you must submit your work through canvas by December 3rd and your work must be typed; otherwise, zero points. 2. Academic Integrity: this is an individual project and you must provide your own work. Copying from other people is not acceptable, both parties involved may receive zero points on the project and any further actions in accordance with CSUB Academic Integrity Policy will follow. 3. How is your work graded: this is a 50 point project which contributes 5% of your final grade. Every question receives up to 10 point. The project will be graded in the following way: Excellent (9-10) Good(7-8) Moderate(5-6) Poor (3-4) Failure(0-2) Question 1,2,3,4,5 Correct numbers, excellent steps and quality of explanations Correct final answer, most steps are correct, explanation is convincing, but may miss some steps Incorrect final answer, most steps are correct, explanation is good, but needs a lot of revisions Incorrect final answers, steps have some major issues, explanation is poor The work needs to be redone and major revisions are required. Wrong answers and explanations Each question will be graded separately. For example, if you receive 10 pts, 9 pts, 5 pts, 7 pts and 2 pts on questions 1-5 respectively, your grade on this project is 10+9+5+7+2=33 points out of 50 in total.