Cost Items and Account Balances
Administrative salaries $15,500
Advertising for Headgears 11,000
Cash, December 1 –0–
Depreciation on factory building 1,500
Depreciation on office equipment 800
Insurance on factory building 1,500
Miscellaneous expenses—factory 1,000
Office supplies expense 300
Professional fees 500
Property taxes on factory building 400
Raw materials used 70,000
Rent on production equipment 6,000
Research and development 10,000
Sales commissions 40,000
Utility costs—factory 900
Wages—factory 70,000
Work in process, December 1 –0–
Work in process, December 31 –0–
Raw materials inventory, December 1 –0–
Raw materials inventory, December 31 –0–
Raw material purchases 70,000
Finished goods inventory, December 1 –0–
Production and Sales Data
Number of Headgears produced 10,000
Expected sales in units for December
($40 unit sales price) 8,000
Expected sales in units for January 10,000
Desired ending inventory 20% of next month’s sales
Direct materials per finished unit 1 kilogram
Direct materials cost $7 per kilogram
Direct labor hours per unit .35
Direct labor hourly rate $20
Each cost is either fixed or variable. There are no mixed costs.
*Assume that Utility costs-factory are fixed costs.*
Prepare a flexible budget for manufacturing costs for activity levels between 8,000 and 10,000 units, in 1,000-unit increments.
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||
8,000 Units | 9,000 Units | 10,000 Units | |||
Direct Material | units*1kg*$7 | $ 56,000 | $ 63,000 | $ 70,000 | |
Direct Labor | units*0.35*$20 | $ 56,000 | $ 63,000 | $ 70,000 | |
Depreciation on factory building | $ 1,500 | $ 1,500 | $ 1,500 | ||
Insurance on factory building | $ 1,500 | $ 1,500 | $ 1,500 | ||
Miscellaneous expenses—factory | $ 1,000 | $ 1,000 | $ 1,000 | ||
Property taxes on factory building | $ 400 | $ 400 | $ 400 | ||
Rent on production equipment | $ 6,000 | $ 6,000 | $ 6,000 | ||
Utility costs—factory | $ 900 | $ 900 | $ 900 | ||
Total manufacturing cost | $ 123,300 | $ 137,300 | $ 151,300 |
please answer questions in excel Namaste Company manufactures a unique yoga mat. The company began operations December 1, 2018. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information...
From the account balances listed below, prepare a schedule of cost of goods manufactured for Sampson Manufacturing Company for the month ended December 31, 2019. Account Balances Finished Goods Inventory, December 31 $42,000 Factory Supervisory Salaries 12,000 Income Tax Expense 18,000 Raw Materials Inventory, December 1 12,000 Work In Process Inventory, December 31 15,000 Sales Salaries Expense 14,000 Factory Depreciation Expense 8,000 Finished Goods Inventory, December 1 35,000 Raw Materials Purchases 105,000 Work In Process Inventory, December 1 25,000 Factory...
Problem: Show all you work. From the account balances listed below, prepare a schedule of cost of goods manufactured for Sampson Manufacturing Company for the month ended December 31, 2016. Finished Goods Inventory, December 31 Factory Supervisory Salaries Income Tax Expense Raw Materials Inventory, December 1 Work In Process Inventory, December 31 Sales Salaries Expense Factory Depreciation Expense Finished Goods Inventory, December 1 Raw Materials Purchases Work In Process Inventory, December 1 Factory Utilities Expense Direct Labor Raw Materials Inventory,...
need help please Required information The following selected account balances are provided for Delray Mfg. Sales Raw materials inventory, beginning Work in process inventory, beginning Finished goods inventory, beginning Raw materials purchases Direct labor Factory supplies used (indirect materials) Indirect labor Repairs-Factory equipment Rent cost of factory building Advertising expense General and administrative expenses Raw materials inventory, ending Work in process inventory, ending Finished goods inventory, ending $ 1,175,000 41,000 51,000 63,000 182,100 228,000 22,400 43,000 5, 250 52,000 84,000...
Required information The following selected account balances are provided for Delray Mfg. $ Sales Raw materials inventory, beginning Work in process inventory, beginning Finished goods inventory, beginning Raw materials purchases Direct labor Factory supplies used (indirect materials) Indirect labor Repairs-Factory equipment Rent cost of factory building Advertising expense General and administrative expenses Raw materials inventory, ending Work in process inventory, ending Finished goods inventory, ending 1,469,000 38,000 53,100 61,000 158,800 241,000 24,000 47,000 5,250 53,000 105,000 135,000 41,000 44,300 71,700...
From the account balances listed below, prepare a schedule of cost of goods manufactured for SeSame Manufacturing Company for the month ended December 31, 2011 with proper heading. Finished Goods Inventory, December 31 $52,000 Factory Supervisory Salaries 14,000 Income Tax Expense 18,000 Raw Materials Inventory, December 1 23,000 Work In Process Inventory, December 31 13,000 Sales Salaries Expense 14,000 Factory Depreciation Expense 6,000 Finished Goods Inventory, December 1 45,000 Raw Materials Purchases 97,000 Work In Process Inventory, December 1 35,000...
Pictures are for part A. Part b asks to compute the cost of producing one helmet Ohno Company specializes in manufacturing a unique model of bicycle helmet. The model is wel ccepted by at 10,000 helmets per month (80% of its full capacity). Ohno's monthly manufacturing cost and other expense data are as follows. Rent on factory equipment $12,100 Insurance on factory building 2,500 Raw materials (plastics, polystyrene, etc.) 77,700 Utility costs for factory 1,000 Supplies for general office 400...
Magic Lady Clean A Magical The Problem: Show all you work. From the account balances listed below, prepare a schedule of cost of goods manufactured Sampson Manufacturing Company for the month ended December 31, 2016 Account Balances $42,000 Finished Goods Inventory, December 31 Factory Supervisory Salaries Income Tax Expense Raw Materials Inventory, December 1 Work In Process Inventory, December 31 Sales Salaries Expense Factory Depreciation Expense Finished Goods Inventory, December 1 Raw Materials Purchases Work In Process Inventory, December 1...
Please help with part 4-9. I will highly apprecite it. The Business Situation Concrete Helmet Company is a newly formed company that manufactures bicycle helmets. The company began operations January 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position Each candidate will be provided with the information below and then asked to prepare a...
Rainy Day Company manufactures a unique umbrella. The company began operations April 1, 2020. Its accountant quit the second week of operations, and the company is searching for a replacement. The company has decided to test the knowledge and ability of all candidates interviewing for the position. Each candidate will be provided with the information below and then asked to prepare a series of reports, schedules, budgets, and recommendations based on that information. The information provided to each candidate is...