Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. M N C E G ! 1 ACCT-5012 - CASE STUDY - F21 Group members 2 Fine Office Company Martin Rubri: 4 Tab Fint
. M N C E G ! 1 ACCT-5012 - CASE STUDY - F21 Group members 2 Fine Office Company Martin Rubri: 4 Tab Fint Office Company makes effio fumiture for offices They are in the process of preparing Salus 6 a Master Sucget including the Cperating budget, Cash Statement, Income Statement Prod.co 7 and Balance Sheet for 2021. The weantudget is brke into cuarters. Tra year end is Di Materas 3 315. December 221 Your group has beengesledo compile : masie- budec. for the Dir. La 9 fica year 2021 Manufacturing 04 10 Package Is to Indude the following bogats; Cost of Ending Finished in 111. Sales budget for each quars and for these COGS 12 Z. Prod.c.or budget forcida quarter and for tee your Selling & Admin 12 3. Purchasing Burget for each quarter and for the year is 14 4. Direct labour budget for each quarr and for the ex (10 5 15 5. Wanufacturing oxhead budget for each quarter and for the year Cash 16 6. Selling and dinistration budget Cash Worksheets 11 7. Worksheets for Collections and Disbursements 3's 13 8. Budgeted here statement Total 19 9.1 me Statemert 2017 Budgele Cash Statement 21 11 Budgete: Ealance Sheet 22 sec Bienal details 2. Fine Of Company procures tau products P100 and 230 24. Sales price per PICC is $1,360 25 Sales price per PCC is $1.440 25. There are 300 unts from P:O) in Finished Foods nventorvether of 2020 with a value of 5 9 of 2.ad yr At the entries star Ene Favrending winterte has alta ... Manualuing Dwered udget Cost of Encing lished werto Cost ofcous Sold Seling... Press Don't use marking cells Mau Points Group Points 0 10 3 13 0 51 0 18 D 12 0 14 01 17 0 18 0 16 0 0 22 0 14 0 24 0 20 0 390,000 500 unitsrom P200 astheerd 1 If the final arter's cabin inte E-- 2 C L F H L M 27 of 2020 cal. 3x, pol. St the end of cashuar., Fine orifice Company rers er ng im.entery abc aqualto 10% of the following cuarta's gated sales in its 25 The required inding inventory for De: 11.2021 are 600 units fer 100 and 1 400 units for 200 29. EP.00 units 135 l. Skeeldur en hulle S. The wst olleetu 2021 s nalel oles sented & DEWI. 30 tich P200 unit ses 1. ft. of steel during to manufacturers 31 Fine Office Company currently has 20,000 sq. . . of steel in the spinning inventory. At 32 : beend alsach artar, Fire Dife Company was to w 135, 1900 sq. ft. oleding 32 nentory 34. Ead procura 1038 machine leurs and 52 cilator produce 35. Dre labeur est $ 38. raahaur hour OR A 50kne company allocates marufacturing overhac rasts bosco-tre stmated machine 57 rostlur 37 hours Estimated menu adring wheed cast for 2021 $ 1.71.1,660 are reallarable, 58. Forcach cuartar, tincstimates that 40 osaks eil be ces and will 50 39 % will be credit sales. O't-e credit sales 50% pay in the quart of the sale and 20par n the 40 Tullowiw. Cheilum 01 2020 were 5.,200000 41. Dreabour costs are manufacturing chicad costs are paid for in cash in the quarter the and 4 OUTS 43. Assine oder gesperater is throughout the year and are widest. 2. For each cuarter 20. of material surchaxsara paid for in in the quarter 5 chase and 30 are paid in the clovir war.m. Purth of materials from 25 nanan ware S15 21 Fine Office Company 20 Solectional dels continued 51. Fine Olie Corpany will pry $0.cco i-dividende i 52. Currently, the eza balance in the bars $15.06. Fine Office Company and amalan 53 minimum sal baande of S:000 in the bank for such cuarter unda ul ... Manultturing Oce_here Budget Coctef Ending riceclerc Coro Sox Sold Soling ... of # + - 19 15667 ! C D E 1 T 1 52. Current the cash balance in the bank : $15, 20nc Office Company warto maircan 53 minimum cash balance of S10 000 inch bank lor enquar... S1 Eudgeted sales volumes are 1100 0 1160 Q 12512 - 2242 4 56 PACO Q: 14035 2 115014 02 4525 24 57. Selling and Administration expenses lur tre buulgele:year are lollows, 58 Variable Cost: 49 Dryssar henta 12 valen fo Commissions are based on 2: of saks vale 61 62 Fixed Costs $ 6 Accountrg & professional services 3600 64 Administrative Sales Salacias. 1400CC 65 Neverlising 200CC 65 Computer costs 90cc 67 Dearesation FUOCO 18 CHior Supplies 50CC 93 621 Printing 3DCC 10 Insurance 4000 71 Property tarcs 2060 T2 Rent 400CG 13 Ulilities 3960 14 Jiotal bed Costs 3.000 75 15. Fnc Office Compny will purchase a new richine on ./1/2021 worth $70000 -d will make two cqual paments. Their payment will be in 32 and he seco din 04. Assume temachine was ' o purchased attic bocnning of the year 9. Taxation 2018 on taxable name and paidatticed of 94 chat zachycar. ... Naufarhring waargent Presto Fecir Finished more of sold Seling E M N C E F 15. Foie Office Company wildene mine u 1/1/2021 runs 7000 and will alweque u ) 77 payments. The fishment will be etisment will be in and the second in the machine was 4. 16 18 purchased the beat ng of the pear. 9. laxations Lwo-taxable incare and parc at the end of each year. 03. Balance sheet normation : :31st December 2020 basolow: 61 PPC $100.000 Accumulated Deprecation $100.000 & Commons $anon Reine Farrings $1450 89. For at of modo 34 Add total costs of radutan Baginning Finlased goods Ending Finked goods Inary. 65. Interes of ! 2000 on loans e paid in toalhe endctrecord is a fised coct. 05 87 85 82 90 91 92 93 95 13 97 99 99 100 101 100 1021 1 Manuteng Overes Budget Cost chening Fingelwente Cost ct Goods Sold Selling ... Par 2 G H 1 M N c P E S. L Max Points Groap Points Total 2 2 2 21 21 21 12 Don't use marking cells E F 1 Ending Finished Goods Inventory Budget P100 2 Cost Element Quantity Cost : Direct Materials 4 + Direct Labour 3+ Manufacturing Overhead 6 = Product Cost Per Unit 2X Ending Inventory In Units 8 Ending Finished Goods Inventory 9 10 Ending Finished Goods Imentory Budget 7200 11 Cost Element Quantity Cost 12 Direct Materials 1: Direct Labour 14 + Manufacturing Overhead 15 Product Cost Per Unit 15 X Ending Inventory In Units 17 Ending Finished Goods Inventory 18 19 20 21 Total 22 24 25 27 Wawatung Ovesd Budget Cost of Ending Finished inwento cost of Good Soling. . FS FI D E F 5 D Nu este Grup Costa Gosd Sald Det material Used 4 Marutacturing Dress Costa 3 Total Cests of Vanstactus 6 Beginning Finished Goods story Lean: Ending flothed Gesuntry A Cost of Good Sold 14 Don't use marking cels 22 12 14 15 M 12 1 21 4 Onge Conting diverto Cost of Goods Som Seling. u N O 0 r STT laryne calls Don't working cele M. Puis R Paris S 7 Cad alates 0 Cross pro 9 Scling and Adminis01ecs waralinga 11 HOPE * Menn 13 lain Net Incane Abertation 19 2 1 2 2 2 2 1 2 2 IS 18 1 Alemany A Cast of Goods Sold $ Wish love! 2 TEAD Venus Menu THIS IS 21 Finlari Grad 2 WAWA It Founang mer 32 33 45 ... Selling Somn budzet Income Statement inccrne Sistement income Sistement Cseh DodgeWerksnel 1 LE - 5 G + N 2 CVF lovce Statillery 3 Dec 1 Denabing.al Was Pants Guips - 10 11 rete costs 12 . 4 Mama Vs Ora... 9 din dreader100.C in durinerlerired warna 17 Borges Goes Oy Tilbud 19 Trbicorturien a gins Lai: 21 de direitos 22.30 13 4 Met how to whernet: .21 31 3 - Selling & Pomn udget Income Statemet CVP Income Statement Chuge Workshet.... ER . M N C E G ! 1 ACCT-5012 - CASE STUDY - F21 Group members 2 Fine Office Company Martin Rubri: 4 Tab Fint Office Company makes effio fumiture for offices They are in the process of preparing Salus 6 a Master Sucget including the Cperating budget, Cash Statement, Income Statement Prod.co 7 and Balance Sheet for 2021. The weantudget is brke into cuarters. Tra year end is Di Materas 3 315. December 221 Your group has beengesledo compile : masie- budec. for the Dir. La 9 fica year 2021 Manufacturing 04 10 Package Is to Indude the following bogats; Cost of Ending Finished in 111. Sales budget for each quars and for these COGS 12 Z. Prod.c.or budget forcida quarter and for tee your Selling & Admin 12 3. Purchasing Burget for each quarter and for the year is 14 4. Direct labour budget for each quarr and for the ex (10 5 15 5. Wanufacturing oxhead budget for each quarter and for the year Cash 16 6. Selling and dinistration budget Cash Worksheets 11 7. Worksheets for Collections and Disbursements 3's 13 8. Budgeted here statement Total 19 9.1 me Statemert 2017 Budgele Cash Statement 21 11 Budgete: Ealance Sheet 22 sec Bienal details 2. Fine Of Company procures tau products P100 and 230 24. Sales price per PICC is $1,360 25 Sales price per PCC is $1.440 25. There are 300 unts from P:O) in Finished Foods nventorvether of 2020 with a value of 5 9 of 2.ad yr At the entries star Ene Favrending winterte has alta ... Manualuing Dwered udget Cost of Encing lished werto Cost ofcous Sold Seling... Press Don't use marking cells Mau Points Group Points 0 10 3 13 0 51 0 18 D 12 0 14 01 17 0 18 0 16 0 0 22 0 14 0 24 0 20 0 390,000 500 unitsrom P200 astheerd 1 If the final arter's cabin inte E-- 2 C L F H L M 27 of 2020 cal. 3x, pol. St the end of cashuar., Fine orifice Company rers er ng im.entery abc aqualto 10% of the following cuarta's gated sales in its 25 The required inding inventory for De: 11.2021 are 600 units fer 100 and 1 400 units for 200 29. EP.00 units 135 l. Skeeldur en hulle S. The wst olleetu 2021 s nalel oles sented & DEWI. 30 tich P200 unit ses 1. ft. of steel during to manufacturers 31 Fine Office Company currently has 20,000 sq. . . of steel in the spinning inventory. At 32 : beend alsach artar, Fire Dife Company was to w 135, 1900 sq. ft. oleding 32 nentory 34. Ead procura 1038 machine leurs and 52 cilator produce 35. Dre labeur est $ 38. raahaur hour OR A 50kne company allocates marufacturing overhac rasts bosco-tre stmated machine 57 rostlur 37 hours Estimated menu adring wheed cast for 2021 $ 1.71.1,660 are reallarable, 58. Forcach cuartar, tincstimates that 40 osaks eil be ces and will 50 39 % will be credit sales. O't-e credit sales 50% pay in the quart of the sale and 20par n the 40 Tullowiw. Cheilum 01 2020 were 5.,200000 41. Dreabour costs are manufacturing chicad costs are paid for in cash in the quarter the and 4 OUTS 43. Assine oder gesperater is throughout the year and are widest. 2. For each cuarter 20. of material surchaxsara paid for in in the quarter 5 chase and 30 are paid in the clovir war.m. Purth of materials from 25 nanan ware S15 21 Fine Office Company 20 Solectional dels continued 51. Fine Olie Corpany will pry $0.cco i-dividende i 52. Currently, the eza balance in the bars $15.06. Fine Office Company and amalan 53 minimum sal baande of S:000 in the bank for such cuarter unda ul ... Manultturing Oce_here Budget Coctef Ending riceclerc Coro Sox Sold Soling ... of # + - 19 15667 ! C D E 1 T 1 52. Current the cash balance in the bank : $15, 20nc Office Company warto maircan 53 minimum cash balance of S10 000 inch bank lor enquar... S1 Eudgeted sales volumes are 1100 0 1160 Q 12512 - 2242 4 56 PACO Q: 14035 2 115014 02 4525 24 57. Selling and Administration expenses lur tre buulgele:year are lollows, 58 Variable Cost: 49 Dryssar henta 12 valen fo Commissions are based on 2: of saks vale 61 62 Fixed Costs $ 6 Accountrg & professional services 3600 64 Administrative Sales Salacias. 1400CC 65 Neverlising 200CC 65 Computer costs 90cc 67 Dearesation FUOCO 18 CHior Supplies 50CC 93 621 Printing 3DCC 10 Insurance 4000 71 Property tarcs 2060 T2 Rent 400CG 13 Ulilities 3960 14 Jiotal bed Costs 3.000 75 15. Fnc Office Compny will purchase a new richine on ./1/2021 worth $70000 -d will make two cqual paments. Their payment will be in 32 and he seco din 04. Assume temachine was ' o purchased attic bocnning of the year 9. Taxation 2018 on taxable name and paidatticed of 94 chat zachycar. ... Naufarhring waargent Presto Fecir Finished more of sold Seling E M N C E F 15. Foie Office Company wildene mine u 1/1/2021 runs 7000 and will alweque u ) 77 payments. The fishment will be etisment will be in and the second in the machine was 4. 16 18 purchased the beat ng of the pear. 9. laxations Lwo-taxable incare and parc at the end of each year. 03. Balance sheet normation : :31st December 2020 basolow: 61 PPC $100.000 Accumulated Deprecation $100.000 & Commons $anon Reine Farrings $1450 89. For at of modo 34 Add total costs of radutan Baginning Finlased goods Ending Finked goods Inary. 65. Interes of ! 2000 on loans e paid in toalhe endctrecord is a fised coct. 05 87 85 82 90 91 92 93 95 13 97 99 99 100 101 100 1021 1 Manuteng Overes Budget Cost chening Fingelwente Cost ct Goods Sold Selling ... Par 2 G H 1 M N c P E S. L Max Points Groap Points Total 2 2 2 21 21 21 12 Don't use marking cells E F 1 Ending Finished Goods Inventory Budget P100 2 Cost Element Quantity Cost : Direct Materials 4 + Direct Labour 3+ Manufacturing Overhead 6 = Product Cost Per Unit 2X Ending Inventory In Units 8 Ending Finished Goods Inventory 9 10 Ending Finished Goods Imentory Budget 7200 11 Cost Element Quantity Cost 12 Direct Materials 1: Direct Labour 14 + Manufacturing Overhead 15 Product Cost Per Unit 15 X Ending Inventory In Units 17 Ending Finished Goods Inventory 18 19 20 21 Total 22 24 25 27 Wawatung Ovesd Budget Cost of Ending Finished inwento cost of Good Soling. . FS FI D E F 5 D Nu este Grup Costa Gosd Sald Det material Used 4 Marutacturing Dress Costa 3 Total Cests of Vanstactus 6 Beginning Finished Goods story Lean: Ending flothed Gesuntry A Cost of Good Sold 14 Don't use marking cels 22 12 14 15 M 12 1 21 4 Onge Conting diverto Cost of Goods Som Seling. u N O 0 r STT laryne calls Don't working cele M. Puis R Paris S 7 Cad alates 0 Cross pro 9 Scling and Adminis01ecs waralinga 11 HOPE * Menn 13 lain Net Incane Abertation 19 2 1 2 2 2 2 1 2 2 IS 18 1 Alemany A Cast of Goods Sold $ Wish love! 2 TEAD Venus Menu THIS IS 21 Finlari Grad 2 WAWA It Founang mer 32 33 45 ... Selling Somn budzet Income Statement inccrne Sistement income Sistement Cseh DodgeWerksnel 1 LE - 5 G + N 2 CVF lovce Statillery 3 Dec 1 Denabing.al Was Pants Guips - 10 11 rete costs 12 . 4 Mama Vs Ora... 9 din dreader100.C in durinerlerired warna 17 Borges Goes Oy Tilbud 19 Trbicorturien a gins Lai: 21 de direitos 22.30 13 4 Met how to whernet: .21 31 3 - Selling & Pomn udget Income Statemet CVP Income Statement Chuge Workshet.... ER
Step 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