Answered step by step
Verified Expert Solution
Question
1 Approved Answer
excel math questions. I filled out the constants section with the information that was given to me but now I need help with the right
excel math questions. I filled out the constants section with the information that was given to me but now I need help with the right side. We are suppose to use the lift side to complete the right side. I am also suppose to use formulas so if anyone can help me out with any part on the right side then that would be amazing. Thanks for any help!
Clipboard Font Alignment X2 Constants Raw Materials Paper Sheets Sheets in a Reum ol Squares per sheet Discount Rate Average per sheet price 1 year Performance Forecast Sales Original Square: $14.978.000.00 500 8 10% Total Sales 3384 56.309,760.00 Paper Sales Aug selling price for original squares $3.76 Variable Expenses Blade cost Advertising Raw Material Cost Total Variable Expenses Labor of employees Annual salary cost Employee daily cutting hours Days in work week work weeks in year Fired Expenses Loan Interest Cutter Cost Payroll Rent Company Insurance Cutter Blade Costs Blade Weinreams Cutter Cost Number of cutters reams per hour 36.000.00 Total Fired Expenses Total Expenses Owner Number of Owners Owner Salary 360.000.00 Income before takes Estimated income tase expense Marginal net income Capital & Other Costs Yearly Rent Companyarance Advertisingle $72,000.00 53000 1200000 $100 50000 30% S 100.00000 Loan Amount Interest Rate 182000 Production Calculations Cost of singlere Cutinghouse Reuscular Sheets Squwe producedyear 2.495.000 Template 1 year Clipboard Font Alignment X2 Constants Raw Materials Paper Sheets Sheets in a Reum ol Squares per sheet Discount Rate Average per sheet price 1 year Performance Forecast Sales Original Square: $14.978.000.00 500 8 10% Total Sales 3384 56.309,760.00 Paper Sales Aug selling price for original squares $3.76 Variable Expenses Blade cost Advertising Raw Material Cost Total Variable Expenses Labor of employees Annual salary cost Employee daily cutting hours Days in work week work weeks in year Fired Expenses Loan Interest Cutter Cost Payroll Rent Company Insurance Cutter Blade Costs Blade Weinreams Cutter Cost Number of cutters reams per hour 36.000.00 Total Fired Expenses Total Expenses Owner Number of Owners Owner Salary 360.000.00 Income before takes Estimated income tase expense Marginal net income Capital & Other Costs Yearly Rent Companyarance Advertisingle $72,000.00 53000 1200000 $100 50000 30% S 100.00000 Loan Amount Interest Rate 182000 Production Calculations Cost of singlere Cutinghouse Reuscular Sheets Squwe producedyear 2.495.000 Template 1 year 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