please use the spread sheet to answer the questions in the second picture ...

50.1K

Verified Solution

Question

Accounting

please use the spread sheet to answer the questions in the second picture
image
image
here is the table in closer form, the second picture is the second half of the sheet
image
image
2025- 2025-A 1 2020- 2020- 2020-Sep e 2121 2021 Mar 2006 Aug 5 7005 2020-Dec . 2021 feb 1 2020-Ort 1 SAR Pod Cabrew 2 300 3 2021 10 SAS TO es REVENJE TOTAL REVENUE 2100 210 210 2130 2200 222 2010 COST OF GOODS SOLD 2839 -505 603 1 . 6655 2000 152 5931 846 6115 20.20 -54 58 MV 923 CE Doch TOTAL COST OF GOODS SOLD GROSS PROFIT GENERAL OPERATIN E PENIS 11.000 11.000 11.00 DOC 000 90025 0 000 000 COOP 000 000 400 000 me 7000 . ONI HING 11450 001 1. TOTAL GENERAL, OPERATING BESES 2 300 . BOTH 500 -10 O wann ADMINISTRATIVE EXPENIES - SONS -100 . - -1100 21.6 35500 TOTAL ADMINISTRATIVE ELENGES TOTAL EXPENSES 30 1000 00 GOVE 08 Please complete the modeling spreadsheet to answer the questions below: 1 15 points What is the EBITDA (Operating Profit) for October 2021 (period 19)? Round to the nearest unit. Type your answer... N 15 points What is the average price per cabinet starting in month 13? Round to 2 decimals. Type your answer... 3 15 points What is the material cost per cabinet starting in month 13? Round to 2 decimals. Enter a negative value. Type your answer... 2020-Apr 1 6450 2020-May 2 6693 2020-Jun 3 6890 2020-Jul 4 7026 2020-Aug 5 7020 Period Cabinet sold 2020-Sep 6 6883 2020-Oct 7 6881 214.00 216.77 213.90 218.28 REVENUE Average price per cabinet TOTAL REVENUE 218.05 217.00 220.67 COST OF GOODS SOLD Material cost per cabinet Labor cost per cabinet TOTAL COST OF GOODS SOLD -65.79 -88.36 -64.55 -87.86 -16.30 -89.23 -59.97 -85.51 -69.30 -84.76 -69.31 -84.68 -61.15 -89 28 GROSS PROFIT GENERAL OPERATING EXPENSES Shop supervisors (2 people) Safety manager Equipment maintenance Equipment repairs TOTAL GENERAL OPERATING EXPENSES -15,000 -8,000 -17,800 -11,450 -15,000 -8.000 -17,800 -11.450 -15,000 -8,000 -17,800 - 11,450 -15,000 -8,000 - 17,800 -11,450 - 15,000 -8,000 -17,800 -11,450 - 15,000 -8,000 - 17,800 -11,450 - 15,000 -8.000 - 17,800 - 11,450 Facilities lease cost Utilities -26,500 -5,300 26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 ADMINISTRATIVE EXPENSES Accounting (payables, receivable, roporting) Managment salaries TOTAL ADMINISTRATIVE EXPENSES - 11,600 -23,500 - 11,000 23,500 -11,600 -23,500 -11,600 23.500 - 11,000 -23,500 - 11,600 -23,500 -11,600 -23,500 TOTAL EXPENSES EBITDA Depreciation (Amort) Expenso Interest Expenso 21,000 -7,000 21,000 -7,000 21,000 -7.600 21,000 -7,600 21,000 -7,000 -21.000 -7.800 21.000 -7.000 2020-Nov 8 7060 2020-Dec 9 2021-Jan 10 6885 2021-Feb 11 6870 2021-Mar 12 7103 2021-Apr 13 2021-M 14 6992 18 222.14 223.07 221.82 218.09 216.68 15 28 -69.40 -92.22 -69.61 -90.07 -64.28 -91.58 -65.73 -88.83 -63.83 -82.86 8888 -15,000 -8,000 -17,800 -11,450 -15,000 -8,000 -17,800 -11,450 -15,000 -8.000 -17.800 - 11.450 - 15,000 -8,000 -17,800 -11,450 -15,000 -8,000 -17,800 -11.450 500 -26,500 -5,300 300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 BOO 500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 000 1600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600 2025- 2025-A 1 2020- 2020- 2020-Sep e 2121 2021 Mar 2006 Aug 5 7005 2020-Dec . 2021 feb 1 2020-Ort 1 SAR Pod Cabrew 2 300 3 2021 10 SAS TO es REVENJE TOTAL REVENUE 2100 210 210 2130 2200 222 2010 COST OF GOODS SOLD 2839 -505 603 1 . 6655 2000 152 5931 846 6115 20.20 -54 58 MV 923 CE Doch TOTAL COST OF GOODS SOLD GROSS PROFIT GENERAL OPERATIN E PENIS 11.000 11.000 11.00 DOC 000 90025 0 000 000 COOP 000 000 400 000 me 7000 . ONI HING 11450 001 1. TOTAL GENERAL, OPERATING BESES 2 300 . BOTH 500 -10 O wann ADMINISTRATIVE EXPENIES - SONS -100 . - -1100 21.6 35500 TOTAL ADMINISTRATIVE ELENGES TOTAL EXPENSES 30 1000 00 GOVE 08 Please complete the modeling spreadsheet to answer the questions below: 1 15 points What is the EBITDA (Operating Profit) for October 2021 (period 19)? Round to the nearest unit. Type your answer... N 15 points What is the average price per cabinet starting in month 13? Round to 2 decimals. Type your answer... 3 15 points What is the material cost per cabinet starting in month 13? Round to 2 decimals. Enter a negative value. Type your answer... 2020-Apr 1 6450 2020-May 2 6693 2020-Jun 3 6890 2020-Jul 4 7026 2020-Aug 5 7020 Period Cabinet sold 2020-Sep 6 6883 2020-Oct 7 6881 214.00 216.77 213.90 218.28 REVENUE Average price per cabinet TOTAL REVENUE 218.05 217.00 220.67 COST OF GOODS SOLD Material cost per cabinet Labor cost per cabinet TOTAL COST OF GOODS SOLD -65.79 -88.36 -64.55 -87.86 -16.30 -89.23 -59.97 -85.51 -69.30 -84.76 -69.31 -84.68 -61.15 -89 28 GROSS PROFIT GENERAL OPERATING EXPENSES Shop supervisors (2 people) Safety manager Equipment maintenance Equipment repairs TOTAL GENERAL OPERATING EXPENSES -15,000 -8,000 -17,800 -11,450 -15,000 -8.000 -17,800 -11.450 -15,000 -8,000 -17,800 - 11,450 -15,000 -8,000 - 17,800 -11,450 - 15,000 -8,000 -17,800 -11,450 - 15,000 -8,000 - 17,800 -11,450 - 15,000 -8.000 - 17,800 - 11,450 Facilities lease cost Utilities -26,500 -5,300 26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 ADMINISTRATIVE EXPENSES Accounting (payables, receivable, roporting) Managment salaries TOTAL ADMINISTRATIVE EXPENSES - 11,600 -23,500 - 11,000 23,500 -11,600 -23,500 -11,600 23.500 - 11,000 -23,500 - 11,600 -23,500 -11,600 -23,500 TOTAL EXPENSES EBITDA Depreciation (Amort) Expenso Interest Expenso 21,000 -7,000 21,000 -7,000 21,000 -7.600 21,000 -7,600 21,000 -7,000 -21.000 -7.800 21.000 -7.000 2020-Nov 8 7060 2020-Dec 9 2021-Jan 10 6885 2021-Feb 11 6870 2021-Mar 12 7103 2021-Apr 13 2021-M 14 6992 18 222.14 223.07 221.82 218.09 216.68 15 28 -69.40 -92.22 -69.61 -90.07 -64.28 -91.58 -65.73 -88.83 -63.83 -82.86 8888 -15,000 -8,000 -17,800 -11,450 -15,000 -8,000 -17,800 -11,450 -15,000 -8.000 -17.800 - 11.450 - 15,000 -8,000 -17,800 -11,450 -15,000 -8,000 -17,800 -11.450 500 -26,500 -5,300 300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 -26,500 -5,300 BOO 500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 -11,600 -23,500 000 1600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600 -21,000 -7,600

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students