Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If it is possible, I need income statements, job cost reporting, ABC costing, and budgets with work. Sales in Units 160,000 Please use for Sales
If it is possible, I need income statements, job cost reporting, ABC costing, and budgets with work.
Sales in Units 160,000 Please use for Sales price per unit Tab 1 Cost of goods sold 21.00 per unit Advertis ing expense 105,000 per quarter Sales Commissions 4.00% of sales Shipping Ad ministratiwe 40,000 per quarter+ per unit Ad ministrative salaries 90,000 per quarter Insurance expense B,000 per quarter Depreciation expense 45,000 per quarter Selling Expenses $150,000 Purchase of raw materials (all direct) Direct Labor Ad ministrative expenses 120,000 Please use for Tab 2 Manufacturing overhead applied to work in process Actual manufacturing overhead cost 112,000 Ending Raw materials (all direct) 42,000$ 45,000 Work in Process 47,000 Finis hed Goods $54,000 $27,000 Manufacturing overhead Selling and ad minis trative overhead Assembling Units Processing Orders Customers Other 5% 5% Selling and ad minis trative overhead 25% 20% Total activity 100 customers OfficeMart orders: 2 customer Please use for Tab 3 8 orders Number of filing cabinets ordered in total 80 units Selling price 5370 per unit Direct materials 5140 per unit Direct labor $40 Year 3 Quarter Year 2 Quarter Budgeted unit sales 20,000 35,000 44,000 50,000 30,000 40,000 $4 per unit Selling price per unit $65,000 Accounts receivable, beginning balance Sales collected in the quarter sales are made Sales collected in the quarter after sales are made Desired ending finished goods inventory is Finished goods inventory, beginning Raw materials required to produce one unit Desired ending inventory of raw materials is Raw materials inventory, beginning 25% of the budgeted unit sales of the next quarter 9,000 units 6 pounds 15% of the next quarter's production needs 23,000 pounds $0.75 per pound Please use for Raw material costs Tab 4 Raw materials purchases are paid 70% in the quarter the purchases are made 30% in the quarter following purchase Accounts payable for raw materials, beginning balan Standard Price inputs Standard Quantity 3.0 pounds Direct materials $5.00 per pound Direct labor 0.60 hours $15.00 per hour Variable manufacturing overhead 0.60 hours $6.00 per hour Please use for Actual results: 1,600 units Tab 5 Actual output Actual variable manufacturing overhead cost $5,200 Actual Quantity Actual price 4,780 pounds $4.90 per pound Actual direct materials cost 1,020 hours $15.75 per hour Actual direct labor cost Time On It, Inc evaluates divisional managers based on ROI. Operating results for the ompany's Northern Division for last year are given below: 1,140,600 690,000 Sales Variable expenses Contrution margin Fixed expenses 450,600 280,000 Please use for 170,600 Tab 6 Net operating income Average divisional operating assets 930,900 The Norther Division has an opportunity to add a new product line as follows: Required investment 220,000 28,000 Net operating income Time On It, Inc's minimum acceptable rate of return 996 Data Forcept, Inc Sales $1,300 $58 Net operating income Average operating assets Minimum required rate of retunn $200 12% Sales in Units 160,000 Please use for Sales price per unit Tab 1 Cost of goods sold 21.00 per unit Advertis ing expense 105,000 per quarter Sales Commissions 4.00% of sales Shipping Ad ministratiwe 40,000 per quarter+ per unit Ad ministrative salaries 90,000 per quarter Insurance expense B,000 per quarter Depreciation expense 45,000 per quarter Selling Expenses $150,000 Purchase of raw materials (all direct) Direct Labor Ad ministrative expenses 120,000 Please use for Tab 2 Manufacturing overhead applied to work in process Actual manufacturing overhead cost 112,000 Ending Raw materials (all direct) 42,000$ 45,000 Work in Process 47,000 Finis hed Goods $54,000 $27,000 Manufacturing overhead Selling and ad minis trative overhead Assembling Units Processing Orders Customers Other 5% 5% Selling and ad minis trative overhead 25% 20% Total activity 100 customers OfficeMart orders: 2 customer Please use for Tab 3 8 orders Number of filing cabinets ordered in total 80 units Selling price 5370 per unit Direct materials 5140 per unit Direct labor $40 Year 3 Quarter Year 2 Quarter Budgeted unit sales 20,000 35,000 44,000 50,000 30,000 40,000 $4 per unit Selling price per unit $65,000 Accounts receivable, beginning balance Sales collected in the quarter sales are made Sales collected in the quarter after sales are made Desired ending finished goods inventory is Finished goods inventory, beginning Raw materials required to produce one unit Desired ending inventory of raw materials is Raw materials inventory, beginning 25% of the budgeted unit sales of the next quarter 9,000 units 6 pounds 15% of the next quarter's production needs 23,000 pounds $0.75 per pound Please use for Raw material costs Tab 4 Raw materials purchases are paid 70% in the quarter the purchases are made 30% in the quarter following purchase Accounts payable for raw materials, beginning balan Standard Price inputs Standard Quantity 3.0 pounds Direct materials $5.00 per pound Direct labor 0.60 hours $15.00 per hour Variable manufacturing overhead 0.60 hours $6.00 per hour Please use for Actual results: 1,600 units Tab 5 Actual output Actual variable manufacturing overhead cost $5,200 Actual Quantity Actual price 4,780 pounds $4.90 per pound Actual direct materials cost 1,020 hours $15.75 per hour Actual direct labor cost Time On It, Inc evaluates divisional managers based on ROI. Operating results for the ompany's Northern Division for last year are given below: 1,140,600 690,000 Sales Variable expenses Contrution margin Fixed expenses 450,600 280,000 Please use for 170,600 Tab 6 Net operating income Average divisional operating assets 930,900 The Norther Division has an opportunity to add a new product line as follows: Required investment 220,000 28,000 Net operating income Time On It, Inc's minimum acceptable rate of return 996 Data Forcept, Inc Sales $1,300 $58 Net operating income Average operating assets Minimum required rate of retunn $200 12%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