Help in *DSS* Excel sheet assignment
boo989
1st_project.xlsDSS_Assn
| Abdulaziz Alrashid | Spring 2014 | |||||||||||
| IS 312 - Spring 2014 | ||||||||||||
| REPRESENTATION | ||||||||||||
| DATABASE | Income Statement | Base Year | Change | Results | ||||||||
| Income | ||||||||||||
| Gross Sales | $2,500,000 | Gross Sales | $2,500,000 | $0 | $2,500,000 | |||||||
| Return Fraction | 4% | Returns and Allowances | $100,000 | $0 | $100,000 | |||||||
| Labor Cost Fraction | 14% | Net Sales | $2,400,000 | $0 | $2,400,000 | |||||||
| Materials Cost Fraction | 23% | |||||||||||
| Fixed Overhead | $70,000 | Expenditures | ||||||||||
| Overhead Fraction | 28% | Labor | $350,000 | $0 | $350,000 | |||||||
| MMandG Fraction | 18% | Materials | $575,000 | $0 | $575,000 | |||||||
| Federal Tax Fraction | 27% | Fixed Overhead | $70,000 | $0 | $70,000 | |||||||
| State Tax Fraction | 8% | Variable Overhead | $259,000 | $0 | $259,000 | |||||||
| Cost of Goods | $1,254,000 | $0 | $1,254,000 | |||||||||
| MODEL | ||||||||||||
| Profit and Taxes | ||||||||||||
| Returns and Allowances | $100,000 | Gross Profit | $1,146,000 | $0 | $1,146,000 | |||||||
| Cost of Goods | $1,254,000 | |||||||||||
| (Total) Overhead | $329,000 | M, M and G | $432,000 | $0 | $432,000 | |||||||
| Variable Overhead | $259,000 | |||||||||||
| MMandG | $432,000 | Profit Before Tax | $714,000 | $0 | $714,000 | |||||||
| Federal Tax | $192,780 | |||||||||||
| State Tax | $57,120 | Federal Tax | $192,780 | $0 | $192,780 | |||||||
| Labor Cost | $350,000 | State tax | $57,120 | $0 | $57,120 | |||||||
| Materials Cost | $575,000 | |||||||||||
| Profit After Tax | $464,100 | $0 | $464,100 | |||||||||
| Net Income | $464,100 | $0 | $464,100 | |||||||||
| Net Sales | $2,400,000 | |||||||||||
| Gross Profit | $1,146,000 | |||||||||||
| Profit Before Tax | $714,000 | |||||||||||
| Profit After Tax | $464,100 |
&A
Page &P
