Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use the spread sheet to answer the questions in the second picture here is the table in closer form, the second picture is the

please use the spread sheet to answer the questions in the second picture
image text in transcribed
image text in transcribed
here is the table in closer form, the second picture is the second half of the sheet
image text in transcribed
image text in transcribed
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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions