Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACC420-065 Spring 2022 Chapter 6 assignment - Total 100 marks. Instructions: 1. Ensure your name and student number are on EACH page of the

image text in transcribed

ACC420-065 Spring 2022 Chapter 6 assignment - Total 100 marks. Instructions: 1. Ensure your name and student number are on EACH page of the assignment in the top right hand corner. 2. Clearly label each question and what part of the question you are answering. Round all calculations to two decimal places. 3. There are 4 questions totaling 100 marks. 4. This assignment must be submitted in a PDF format only. If you are using WORD or EXCEL you will have to print your assignment to "Microsoft PDF Writer instead of selecting a printer. Make sure you re-size it to fit on 1 page wide only. For handwritten assignments, they must be scanned and also saved as a PDF document. All other submission formats will not be accepted. 5. NOTE: If I cannot read the assignment, I will not be able to mark it and students will receive a grade of "0" This assignment is due May 30, 2022 at 11:59 pm and is worth 4% of your final grade-LATE submissions will not be accepted. Question #1 (100 Marks) Tiny Toons was established on January 1, 2022 capitalized though the issuance of common shares for $85,000. Tiny Toons produces miniature, plastic cartoon characters Their 2022 estimated sales are 50,000 units at $120 per unit. Tiny Toons desires an ending Inventory of 5,000 units and there is no beginning inventory. 30% of sales are cash and 70% are credit card. The credit card charges a 3% service charge, with 80% of the credit card sales are collected in the current period and 20% in the following period. 90% of the raw material purchases are paid for during the period of purchase, 10% paid in the following period. Materials cost $100 per unit and Tiny Toons desires an ending inventory for raw materials of 25 units. Direct Labour Costs are paid in the period incurred and are $20 per hour and it takes 1 and hours to produce one unit. Manufacturing overhead is allocated based on direct labour hours at $30 per hour. Manufacturing equipment cost $35,000, salvage value $5,000, 5 year useful life All overhead costs (excluding depreciation) are paid in the period incurred as follows: Salary expense $150,000, Sales Commissions $175,000, Sales Supplies $25,000, Rent $75,000 and miscellaneous expenses of $5,000. They require a cash balance of $601,100 and to maintain this cash balance, a line of credit is available for 3% per annum. Note: All borrowings and repayments occur on the first day of the period. REQUIRED: 1. Prepare a Sales Budget (3 marks) 2. Prepare a Production Budget (5 marks)) 3. Prepare a Raw Materials Budget (10 marks) 4. Prepare a Direct Manufacturing Labour Budget (5 marks) 5. Prepare a Manufacturing Overhead Budget (3 marks) 6. Prepare a Cost of Goods Manufactured Budget and a unit cost (7 marks) 7. Prepared a Selling, General and Administrative Expenses Budget (6 marks) 8. Prepare a Proforma Income Statement (7 marks) 9. Prepare a Cash Receipts Schedule (4 marks) 10. Prepare a Credit Cards Proforma Data Schedule (3 marks) 11. Prepare a Cash Payments Budget (4 marks] 12. Prepare proforma data for accounts payable, raw material inventory and accumulated deprecation, Finished Goods Inventory December 31, 2022 and Cost of Goods Sold (5 marks) 13. Prepare a Cash Budget (21 marks) 14. Prepare a Proforma Balance Sheet (17 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Excel & Access for Accounting 2010

Authors: Glenn Owen

3rd edition

1111532672, 978-1111532673

More Books

Students also viewed these Accounting questions

Question

Why do bars offer free peanuts?

Answered: 1 week ago