Question

1 Approved Answer

Posted on Jul 31, 2024

Find and enter the Variable Expenses for all those that apply using the accounting ledger. Quarters 1-4 reflect year one, while quarter 5-8 reflect year

Find and enter the Variable Expenses for all those that apply using the accounting ledger. Quarters 1-4 reflect year one, while quarter 5-8 reflect year two. Must show your work.

image text in transcribed

B G H Year 1 Revenue Fixed Expenses Variable Expenses 46.91 Cost of Goods Sold 46.91 6 Operating Expenses General and Admin Human Resources Benefits and Programs Sales & Marketing Research and Development Other 10 11 12 13 SubTotal 14 EBT 15 Taxes @ 16 Net Income 3.85 23.34 6.81 5.22 21.19 6.75 67.16 17 18 14,500 Quanity of Output Variable Cost Per Unit of Output 19 20 Period Units Produced Units Expired Units Sold Units in Inventory 2,000 4,111 500 2,694 2,111 6,200 3,448 4,305 5,800 4,247 1,553 4,500 5,891 4,500 3,223 1,391 3,000 2,886 114 2,500 2,500 REVENUE PROFIT MINUS EQUALS Money COGS & EXPENSES Money PAID RECEIVED Money MADE or LOST $445,377,594 $239,671,249 $205,706,345 P1-P4 P5 P6 P7 P8 Total All-Time Revenue 216 65.40 53.10 50.92 60.21 445 Cost of Goods Sold 46.91 15.16 12.31 9.62 16.73 101 Other Income 0.00 0.00 0.00 0.00 0.00 0.00 SubTotal 169 50.24 40.7941.30 43.48 345 Operating Expenses General and Administrative 3.85 0.96 0.96 0.96 0.96 7.70 1.21 3.39 Human Resources Research & Development Production Sales & Marketing Operations Management 3.82 8.38 0.99 0.90 1.75 1.29 3.32 0.34 0.34 0.65 0.54 0.35 0.69 1.21 0.30 0.76 0.12 0.22 1.25 1.32 0.48 0.19 0.36 8.77 16.71 3.10 1.90 3.67 Benefits and Programs Hiring Costs Severance Costs Training Costs Turnover Costs 6.81 0.29 0.06 0.19 0.15 2.56 0.13 0.00 0.00 0.05 2.66 0.04 0.01 0.00 0.05 1.12 0.03 0.45 0.00 0.02 1.54 0.15 0.03 0.00 0.05 14.69 0.64 0.55 0.19 0.31 Expired Units 0.00 0.00 0.00 0.00 0.00 0.00 Inventory Carrying Costs 0.05 0.05 0.13 0.06 0.00 0.28 Loan Interest Payments 0.00 0.00 0.00 0.00 0.00 0.00 Sales & Marketing Advertising - Brand - USA Advertising - Brand - Canada Advertising - Brand - Mexico 2.55 0.28 0.50 0.70 0.35 0.30 1.00 0.60 0.50 1.60 0.80 0.75 1.00 0.40 0.50 6.85 2.43 2.55 Advertising - Price Discount - USA Advertising - Price Discount - Canada Advertising - Price Discount - Mexico 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sales Promotion - USA Sales Promotion - Canada Sales Promotion - Mexico 1.35 0.19 0.35 0.30 0.25 0.20 0.50 0.40 0.30 0.75 0.40 0.40 0.55 0.25 0.25 3.45 1.49 1.50 Sales Promotion - USA Sales Promotion - Canada Sales Promotion - Mexico 1.35 0.19 0.35 0.30 0.25 0.20 0.50 0.40 0.30 0.75 0.40 0.40 0.55 0.25 0.25 3.45 1.49 1.50 Research & Development Trained Service Reps System Size (Tons) SEER Rating Quietness Change costs to update processes/equipment Change costs to upgrade product inventory 18.00 0.85 0.45 0.40 1.40 0.09 7.00 0.25 0.15 0.25 0.38 0.00 7.00 0.25 0.15 0.25 0.00 0.00 7.00 0.25 0.15 0.25 0.00 0.00 4.00 0.25 0.23 0.25 0.45 2.64 43.00 1.85 1.13 1.40 2.23 2.72 Other Expansion to other territories Market Research Reports Miscellaneous Expenses Legal 0 4.00 2.75 0.00 0.00 0.00 1.28 0.00 0.00 0.00 .48 0.00 0.00 0.00 0.98 0.00 0.00 0.00 0.38 0.00 0.00 4.00 5.85 0.00 0.00 SubTotal 60.38 21.08 21.44 18.58 17.46 139 Net Profit (Loss) 108 29.16 19.35 22.72 26.02 206 Production and Distribution Quarter Quietness Units to Produce Unit Cost System Size (Tons) $1,400.00 $1,100.00 SEER Rating Trans Cost Units in Inventory Units Units Expire After Expired 2,000 $1,250.00 $250.00 $70.00 0 8 Quarters 0 500 $1,100.00 $750.00 $250.00 $108.50 2,111 8 Quarters $1,400.00 $1.232.00 6,200 $1,100.00 $750.00 $250.00 $70.00 4,305 8 Quarters 5,800 $1,400.00 $1,100.00 $750.00 $250.00 $70.00 1,553 8 Quarters 4,500 $1,400.00 $750.00 $100.00 $70.00 0 8 Quarters 4,500 $1,100.00 $1,100.00 $1,100.00 $750.00 $100.00 $50.00 1,391 8 Quarters $1,400.00 $1,680.00 $1,400.00 3,000 $350.00 $100.00 $39.00 114 8 Quarters 2,500 $1,000.00 $350.00 $100.00 $30.00 8 Quarters Year 1 2 Revenue Fixed Expenses Variable Expenses 46.91_ 4 Cost of Goods Sold 46.91 6 Operating Expenses General and Admin Human Resources Benefits and Programs Sales & Marketing Research and Development Other 3.85 23.34 6.81 5.22 11 21.19 6.75 67.16 13 SubTotal 74 EBT 15 Taxes @ 16 Net Income 17 14,500 18 19 Quanity of Output Variable Cost Per Unit of Output B G H Year 1 Revenue Fixed Expenses Variable Expenses 46.91 Cost of Goods Sold 46.91 6 Operating Expenses General and Admin Human Resources Benefits and Programs Sales & Marketing Research and Development Other 10 11 12 13 SubTotal 14 EBT 15 Taxes @ 16 Net Income 3.85 23.34 6.81 5.22 21.19 6.75 67.16 17 18 14,500 Quanity of Output Variable Cost Per Unit of Output 19 20 Period Units Produced Units Expired Units Sold Units in Inventory 2,000 4,111 500 2,694 2,111 6,200 3,448 4,305 5,800 4,247 1,553 4,500 5,891 4,500 3,223 1,391 3,000 2,886 114 2,500 2,500 REVENUE PROFIT MINUS EQUALS Money COGS & EXPENSES Money PAID RECEIVED Money MADE or LOST $445,377,594 $239,671,249 $205,706,345 P1-P4 P5 P6 P7 P8 Total All-Time Revenue 216 65.40 53.10 50.92 60.21 445 Cost of Goods Sold 46.91 15.16 12.31 9.62 16.73 101 Other Income 0.00 0.00 0.00 0.00 0.00 0.00 SubTotal 169 50.24 40.7941.30 43.48 345 Operating Expenses General and Administrative 3.85 0.96 0.96 0.96 0.96 7.70 1.21 3.39 Human Resources Research & Development Production Sales & Marketing Operations Management 3.82 8.38 0.99 0.90 1.75 1.29 3.32 0.34 0.34 0.65 0.54 0.35 0.69 1.21 0.30 0.76 0.12 0.22 1.25 1.32 0.48 0.19 0.36 8.77 16.71 3.10 1.90 3.67 Benefits and Programs Hiring Costs Severance Costs Training Costs Turnover Costs 6.81 0.29 0.06 0.19 0.15 2.56 0.13 0.00 0.00 0.05 2.66 0.04 0.01 0.00 0.05 1.12 0.03 0.45 0.00 0.02 1.54 0.15 0.03 0.00 0.05 14.69 0.64 0.55 0.19 0.31 Expired Units 0.00 0.00 0.00 0.00 0.00 0.00 Inventory Carrying Costs 0.05 0.05 0.13 0.06 0.00 0.28 Loan Interest Payments 0.00 0.00 0.00 0.00 0.00 0.00 Sales & Marketing Advertising - Brand - USA Advertising - Brand - Canada Advertising - Brand - Mexico 2.55 0.28 0.50 0.70 0.35 0.30 1.00 0.60 0.50 1.60 0.80 0.75 1.00 0.40 0.50 6.85 2.43 2.55 Advertising - Price Discount - USA Advertising - Price Discount - Canada Advertising - Price Discount - Mexico 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sales Promotion - USA Sales Promotion - Canada Sales Promotion - Mexico 1.35 0.19 0.35 0.30 0.25 0.20 0.50 0.40 0.30 0.75 0.40 0.40 0.55 0.25 0.25 3.45 1.49 1.50 Sales Promotion - USA Sales Promotion - Canada Sales Promotion - Mexico 1.35 0.19 0.35 0.30 0.25 0.20 0.50 0.40 0.30 0.75 0.40 0.40 0.55 0.25 0.25 3.45 1.49 1.50 Research & Development Trained Service Reps System Size (Tons) SEER Rating Quietness Change costs to update processes/equipment Change costs to upgrade product inventory 18.00 0.85 0.45 0.40 1.40 0.09 7.00 0.25 0.15 0.25 0.38 0.00 7.00 0.25 0.15 0.25 0.00 0.00 7.00 0.25 0.15 0.25 0.00 0.00 4.00 0.25 0.23 0.25 0.45 2.64 43.00 1.85 1.13 1.40 2.23 2.72 Other Expansion to other territories Market Research Reports Miscellaneous Expenses Legal 0 4.00 2.75 0.00 0.00 0.00 1.28 0.00 0.00 0.00 .48 0.00 0.00 0.00 0.98 0.00 0.00 0.00 0.38 0.00 0.00 4.00 5.85 0.00 0.00 SubTotal 60.38 21.08 21.44 18.58 17.46 139 Net Profit (Loss) 108 29.16 19.35 22.72 26.02 206 Production and Distribution Quarter Quietness Units to Produce Unit Cost System Size (Tons) $1,400.00 $1,100.00 SEER Rating Trans Cost Units in Inventory Units Units Expire After Expired 2,000 $1,250.00 $250.00 $70.00 0 8 Quarters 0 500 $1,100.00 $750.00 $250.00 $108.50 2,111 8 Quarters $1,400.00 $1.232.00 6,200 $1,100.00 $750.00 $250.00 $70.00 4,305 8 Quarters 5,800 $1,400.00 $1,100.00 $750.00 $250.00 $70.00 1,553 8 Quarters 4,500 $1,400.00 $750.00 $100.00 $70.00 0 8 Quarters 4,500 $1,100.00 $1,100.00 $1,100.00 $750.00 $100.00 $50.00 1,391 8 Quarters $1,400.00 $1,680.00 $1,400.00 3,000 $350.00 $100.00 $39.00 114 8 Quarters 2,500 $1,000.00 $350.00 $100.00 $30.00 8 Quarters Year 1 2 Revenue Fixed Expenses Variable Expenses 46.91_ 4 Cost of Goods Sold 46.91 6 Operating Expenses General and Admin Human Resources Benefits and Programs Sales & Marketing Research and Development Other 3.85 23.34 6.81 5.22 11 21.19 6.75 67.16 13 SubTotal 74 EBT 15 Taxes @ 16 Net Income 17 14,500 18 19 Quanity of Output Variable Cost Per Unit of Output