See attached file.
1. Compare and contrast standards and budgets.
2. Compute the variable overhead total, spending and efficiency variances for manufacturing overhead given the following information. Actual hours x1000, standard hours 900, standard rate $1.5/hours and actual rate $1.25/hour.
3. Given the following information compute the ROI and intermediate values using the DuPont approach. What would be the impact on ROI if sales increase by 5%?
? Based on a 5% increase in sales without any increase in operating assets results in an increase to net operating income of 25%, up $50,000 to $250,000. As such, ROI jumps up to 5.62% from 4.49% and margin is improved to 23.81% (up 3.81 percentage points). Margin has improved here as sales increased and assuming operating expenses remained constant. Turnover is slightly higher due to the increase in sales and assuming average operating assets remained constant.
Selling Expense 200,000
Administrative Expense 100,000
Plant & Equipment 1,500,000
Other Assets 2,300,000
Long term debt 5,000,000
4. Create a cash budget given the following information. How would we deal with the result (whether it is a deficit or surplus)?
? Given the information provided the cash budget results in a cash excess. As such the excess funds could be utilized to repay funds borrowed in previous periods (and current period). Additionally, if no outstanding debt exits (or the company chooses to pay a portion of debt outstanding) then the excess funds could be invested in investments/securities or re-invested into the company (increase its equity base or be applied to asset purchases, etc.). Ultimately the excess cash may be utilized by the company in anyway it chooses, however the excess cash should improve the company's overall position (in reference to liquidity (more cash or liquid investments if company invests excess cash) and leverage (reduction of debt in company retires or pay downs a potion of existing debt outstanding with excess cash).
Beginning cash 50,000
*Depreciation & amortization are excluded; non-cash items.© BrainMass Inc. brainmass.com October 16, 2018, 7:43 pm ad1c9bdddf
This solution is comprised of a detailed explanation to compare and contrast standards and budgets, compute the variable overhead total, spending and efficiency variances for manufacturing overhead, compute the ROI and intermediate values using the DuPont approach, and create a cash budget.
Accounting Problems: Varying Predetermined Overhead Rates and Javadi Company
(See attached file for full problem description)
EXERCISE 2-10 Varying Predetermined Overhead Rates (LO3, LO5)
Javadi Company makes a composting bin that is subject to wide seasonal variations in demand. Unit Product costs are computed on a quarterly basis by dividing each quarter's manufacturing costs ( materials, labor, and overhead) by the quarter's production in units. The company estimated costs, by quarter, for the coming year are given below:
First Second Third Fourth
Direct Materials $240,000 $120,000 $60,000 $180,000
Direct labor 96,000 48,000 24,000 72,000
Manufacturing costs 228,000 204,000 192,000 216,000
Total manufacturing costs $564,000 $372,000 $276,000 $468,000
Number of units to be produced 80,000 40,000 20,000 60,000
Estimated unit product cost $7.05 $9.30 $13.80 $7.80
Management finds the variation in the unit product costs to be confusing and difficult to work with. It has been suggested that the problem lies with manufacturing overhead, since it is the largest element of cost. Accordingly, you have been asked to find more appropriate way of assigning manufacturing overhead cost to units of product. After some analysis, you have determined that the company's overhead costs are mostly fixed and therefore show little sensitivity to changes in the level of production.
1. The company uses a job - order costing system. How would you recommend that manufacturing overhead cost be assigned to production? Be specific, and show computations.
2. Recompute the company's unit costs in accordance with your recommendations in (1) above.
EXERCISE 3-9 Assigning Overhead to Products in ABC (LO3)
Refer to the data in Exercise 3-8 for Sultan Company. The activities during the year were distributed across the company's four products as follows:
Actual Product Product Product Product
Activity Cost Pool Activity A B C D
Labor related 25,000 DLHs 6,000 10,000 4,000 5,000
Purchase orders 200 orders 60 30 20 90
Parts management 110 parts type 30 25 40 15
Board etching 1,800 boards 500 900 400 0
General Factory 22,000 MHs 3,000 8,000 5,000 6,000
Compute the amount of overhead cost applied to each product during the year.
PROBLEM 4-17 Comprehensive Process Costing Problem - Weighted -Average
Method (LO1, LO2, LO3, LO4, LO5)
Techno Co. produces a special kind of tool that is widely used by construction. The tool is produced in two processes: bending and drilling. Raw materials are introduced at various points in the Bending Department; labor and overhead costs are incurred evenly through the bending operation. The bent output is then transferred to the Drilling Department.
The following incomplete Work in Process account has been provided for the Bending Department for May:
Work in Process - Bending Department
May 1 inventory (12,000 units; materials 80%
complete; labor and overhead 60%
May costs dded:
Raw materials (270,000 units) 394,210
Direct labor 638,144
? Completed and transferred
To drilling ( ? Units)
May 31 inventory (9,000; materials
90% complete; labor
and overhead 60% complete) ?
The May 1 work in process inventory in the Bending Department consists of the following cost elements: raw materials, $13,385; direct labor, $18,880; and overhead, $13,104. Costs incurred during May in the Drilling Department were: materials used, $100,800; direct labor, $250,600; and overhead cost applied to production, $189,000.
The company accounts for units and costs using the weighted-average method.
1. Prepare journal entries to record the costs incurred in both the Bending Department and the Drilling Department during May. Key your entries to the items (a) through (g) below.
a. Raw materials were issued for use in production.
b. Direct labor costs were incurred.
c. Manufacturing overhead costs for the entire factory were incurred, $685,000. (Credit Accounts Payable.)
d. Manufacturing overhead cost was applied to production using a predetermined overhead rate.
e. Units that were complete as to processing in the Bending Department were transferred to eh Drilling Department, $1,536,990.
f. Units that were complete as to processing in the Drilling Department were transferred to Finished Good, $1,650,000.
g. Completed units were sold on account, $2,700,000. the Cost of Goods Sold was $1,600,000.
2. Post the journal entries from (1) above T-accounts. The following account balances existed at the beginning of May. (the beginning balance in the Bending Department's Work in Process account is given above.)
Raw Materials $500,000
Work in Process-Drilling Department $10,000
Finished Goods $110,000
After posting the entries to the T-accounts, find the ending balance in the inventory accounts and the manufacturing overhead accounts.
3. Prepare a production report for the Bending Department for May.View Full Posting Details