The beginning inventory at Midnight Supplies and data on purchases and sales for a three month period ending March 31 are as follows:
|
Date |
Transaction |
Number of Units |
Per Unit |
Total |
|
| Jan. | 1 | Inventory | 2,600 | $58.00 | $150,800 |
| 10 | Purchase | 7,200 | 66.00 | 475,200 | |
| 28 | Sale | 3,950 | 116.00 | 458,200 | |
| 30 | Sale | 1,300 | 116.00 | 150,800 | |
| Feb. | 5 | Sale | 500 | 116.00 | 58,000 |
| 10 | Purchase | 17,500 | 68.00 | 1,190,000 | |
| 16 | Sale | 9,200 | 121.00 | 1,113,200 | |
| 28 | Sale | 8,000 | 121.00 | 968,000 | |
| Mar. | 5 | Purchase | 14,400 | 69.60 | 1,002,240 |
| 14 | Sale | 10,100 | 121.00 | 1,222,100 | |
| 25 | Purchase | 3,300 | 70.00 | 231,000 | |
| 30 | Sale | 7,900 | 121.00 | 955,900 | |
| Instructions | |
| 1. | Record the inventory, purchases, and cost of goods sold data in
a perpetual inventory record similar to the one illustrated in
Exhibit 3 , using the first-in, first-out method. |
| 2. | Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account and date your journal entry March 31. Refer to the Chart of Accounts for exact wording of account titles. |
| 3. | Determine the gross profit from sales for the period. |
| 4. | Determine the ending inventory cost as of March 31. |
| 5. |
Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower? |
| CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Midnight Supplies | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in
Exhibit 3
, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.
| Date | Purchases | Cost of Goods Sold | Inventory | ||||||
| Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
| Jan. 1 | |||||||||
| 10 | |||||||||
| 10 | |||||||||
| 28 | |||||||||
| 28 | |||||||||
| 30 | |||||||||
| Feb. 5 | |||||||||
| 10 | |||||||||
| 10 | |||||||||
| 16 | |||||||||
| 16 | |||||||||
| 28 | |||||||||
| Mar. 5 | |||||||||
| 5 | |||||||||
| 14 | |||||||||
| 14 | |||||||||
| 25 | |||||||||
| 25 | |||||||||
| 30 | |||||||||
| 30 | |||||||||
| 31 | Balances | ||||||||
2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account and date your journal entry March 31. Refer to the Chart of Accounts for exact wording of account titles.
Question not attempted.
PAGE 10
JOURNAL
ACCOUNTING EQUATION
Score: 0/51
| DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT | ASSETS | LIABILITIES | EQUITY | |
|---|---|---|---|---|---|---|---|---|
|
1 |
||||||||
|
2 |
||||||||
|
3 |
||||||||
|
4 |
3. Determine the gross profit from sales for the period.
In: Accounting
Job Order Cost Sheet
Remnant Carpet Company sells and installs commercial carpeting for office buildings. Remnant Carpet Company uses a A type of cost accounting system that provides for a separate record of the cost of each particular quantity of product that passes through the factory.job order cost system. When a prospective customer asks for a price quote on a job, the estimated cost data are inserted on an unnumbered An account in the work in process subsidiary ledger in which the costs charged to a particular job order are recorded.job cost sheet. If the offer is accepted, a number is assigned to the job, and the costs incurred are recorded in the usual manner on the job cost sheet. After the job is completed, reasons for the variances between the estimated and actual costs are noted on the sheet. The data are then available to management in evaluating the efficiency of operations and in preparing quotes on future jobs. On October 1, Remnant Carpet Company gave Jackson Consulting an estimate of $9,450 to carpet the consulting firm’s newly leased office. The estimate was based on the following data:
| Estimated direct materials: | |
| 200 meters at $35 per meter | $7,000 |
| Estimated direct labor: | |
| 16 hours at $20 per hour | 320 |
| Estimated factory overhead (75% of direct labor cost) | 240 |
| Total estimated costs | $7,560 |
| Markup (25% of production costs) | 1,890 |
| Total estimate | $9,450 |
On October 3, Jackson Consulting signed a purchase contract, and the delivery and installation were completed on October 10.
The related The form or electronic transmission used by a manufacturing department to authorize materials issuances from the storeroom.materials requisitions and The form on which the amount of time spent by each employee and the labor cost incurred for each individual job, or for factory overhead, are recorded.time tickets are summarized as follows:
| Materials Requisition No. | Description | Amount | |
| 112 | 140 meters at $35 | $4,900 | |
| 114 | 68 meters at $35 | 2,380 | |
| Time Ticket No. | Description | Amount | |
| H10 | 10 hours at $20 | $200 | |
| H11 | 10 hours at $20 | 200 | |
Required:
Enter amounts as positive numbers.
1. Complete that portion of the job order cost sheet that would be prepared when the estimate is given to the customer.
2. Record the costs incurred, and complete the job order cost sheet.
| JOB ORDER COST SHEET | |||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Amount | Amount | Amount | |||||||||||||||||||||||||||||||||||||||||||||
| 200 Meters at $35 | $ | 16 Hours at $20 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total cost | $ | ||||||||||||||||||||||||||||||||||||||||||
| ACTUAL | |||||||||||||||||||||||||||||||||||||||||||||||
| Direct Materials | Direct Labor | Summary | |||||||||||||||||||||||||||||||||||||||||||||
| Mat. Req. No. | Description | Amount | Time Ticket No. | Description | Amount | Item | Amount | ||||||||||||||||||||||||||||||||||||||||
| 112 | 140 Meters at $35 | $ | H10 | 10 Hours at $20 | $ | Direct Materials | $ | ||||||||||||||||||||||||||||||||||||||||
| Direct Labor | |||||||||||||||||||||||||||||||||||||||||||||||
| 114 | 68 Meters at $35 | H11 | 10 Hours at $20 | Factory Overhead | |||||||||||||||||||||||||||||||||||||||||||
| Total | $ | Total | $ | Total Cost | $ | ||||||||||||||||||||||||||||||||||||||||||
Feedback
What is the best explanation for the variances between actual costs and estimated costs. (For this purpose, assume that the additional meters of material used in the job were spoiled, the factory overhead rate has proven to be satisfactory, and an inexperienced employee performed the work.)
The direct materials cost exceeded the estimate by $280 because 8 meters of materials were spoiled. The direct labor cost exceeded the estimate by $80 because an additional 4 hours of labor were used by an inexperienced employee. The factory overhead cost exceeded the estimate because an additional $60 of factory overhead was allocated because of the increase in direct labor.
Management didn't provide enough direction to complete tasks on budget.
The direct materials cost exceeded the estimate by $75 because 3 meters of materials were spoiled.
The direct labor cost exceeded the estimate by $120 because an additional 4 hours of labor were used by an inexperienced employee.
Select the correct answer from the above choices.
a
b
c
d
In: Accounting
Fenway Electronics produces video games in three market categories: commercial, home, and miniature. Fenway has traditionally allocated overhead costs to the three products using the companywide allocation base of direct labor hours. The company recently implemented an ABC system when it installed computer-controlled assembly stations that rendered the traditional costing system ineffective. In implementing the ABC system, the company identified the following activity cost pools and cost drivers:
| Category | Total Pooled Cost | Types of Costs | Cost Driver | |||
| Unit | $ | 360,000 | Indirect labor wages, supplies, factory utilities, machine maintenance | Machine hours | ||
| Batch | 194,400 | Materials handling, inventory storage, labor for setups,packaging, labeling and shipping, scheduling | Number of production orders | |||
| Product | 105,600 | Research and development | Time spent by research department | |||
| Facility | 300,000 | Rent, general utilities, maintenance, facility depreciation, admin. salaries | Square footage | |||
Additional data for each of the product lines follow:
| Commercial | Home | Miniature | Total | ||||||||||||
| Direct materials cost | $ | 25.00 | /unit | $ | 15.00 | /unit | $ | 12.00 | /unit | — | |||||
| Direct labor cost | $ | 10.00 | /hour | $ | 8.00 | /hour | $ | 9.00 | /hour | — | |||||
| Number of labor hours | 6,000 | 12,000 | 2,000 | 20,000 | |||||||||||
| Number of machine hours | 10,000 | 45,000 | 25,000 | 80,000 | |||||||||||
| Number of production orders | 200 | 2,000 | 800 | 3,000 | |||||||||||
| Research and development time | 10 | % | 20 | % | 70 | % | 100 | % | |||||||
| Number of units | 15,000 | 45,000 | 14,000 | 74,000 | |||||||||||
| Square footage | 20,000 | 50,000 | 30,000 | 100,000 | |||||||||||
Required
Determine the total cost and cost per unit for each product line, assuming that overhead costs are allocated to each product line using direct labor hours as a companywide allocation base. Also determine the combined cost of all three product lines.
Determine the total cost and cost per unit for each product line, assuming that an ABC system is used to allocate overhead costs. Determine the combined cost of all three product lines.
(For all requirements, round intermediate calculations and "Cost per Unit" to 2 decimal places.)
In: Accounting
Fenway Electronics produces video games in three market categories: commercial, home, and miniature. Fenway has traditionally allocated overhead costs to the three products using the companywide allocation base of direct labor hours. The company recently implemented an ABC system when it installed computer-controlled assembly stations that rendered the traditional costing system ineffective. In implementing the ABC system, the company identified the following activity cost pools and cost drivers:
| Category | Total Pooled Cost | Types of Costs | Cost Driver | |||
| Unit | $ | 360,000 | Indirect labor wages, supplies, factory utilities, machine maintenance | Machine hours | ||
| Batch | 194,400 | Materials handling, inventory storage, labor for setups,packaging, labeling and shipping, scheduling | Number of production orders | |||
| Product | 105,600 | Research and development | Time spent by research department | |||
| Facility | 300,000 | Rent, general utilities, maintenance, facility depreciation, admin. salaries | Square footage | |||
Additional data for each of the product lines follow:
| Commercial | Home | Miniature | Total | ||||||||||||
| Direct materials cost | $ | 25.00 | /unit | $ | 15.00 | /unit | $ | 12.00 | /unit | — | |||||
| Direct labor cost | $ | 10.00 | /hour | $ | 8.00 | /hour | $ | 9.00 | /hour | — | |||||
| Number of labor hours | 6,000 | 12,000 | 2,000 | 20,000 | |||||||||||
| Number of machine hours | 10,000 | 45,000 | 25,000 | 80,000 | |||||||||||
| Number of production orders | 200 | 2,000 | 800 | 3,000 | |||||||||||
| Research and development time | 10 | % | 20 | % | 70 | % | 100 | % | |||||||
| Number of units | 15,000 | 45,000 | 14,000 | 74,000 | |||||||||||
| Square footage | 20,000 | 50,000 | 30,000 | 100,000 | |||||||||||
Required
Determine the total cost and cost per unit for each product line, assuming that overhead costs are allocated to each product line using direct labor hours as a companywide allocation base. Also determine the combined cost of all three product lines.
Determine the total cost and cost per unit for each product line, assuming that an ABC system is used to allocate overhead costs. Determine the combined cost of all three product lines.
(For all requirements, round intermediate calculations and "Cost per Unit" to 2 decimal places.)
In: Accounting
Several items are omitted from the income statement and cost of
goods manufactured statement data for two different companies for
the month of December:
| On Company |
Off Company |
|||
| Materials inventory, December 1 | $88,800 | $119,880 | ||
| Materials inventory, December 31 | (a) | 135,460 | ||
| Materials purchased | 225,550 | (a) | ||
| Cost of direct materials used in production | 237,980 | (b) | ||
| Direct labor | 334,780 | 269,730 | ||
| Factory overhead | 103,900 | 134,270 | ||
| Total manufacturing costs incurred in December | (b) | 775,620 | ||
| Total manufacturing costs | 847,160 | 1,064,530 | ||
| Work in process inventory, December 1 | 170,500 | 288,910 | ||
| Work in process inventory, December 31 | 143,860 | (c) | ||
| Cost of goods manufactured | (c) | 768,430 | ||
| Finished goods inventory, December 1 | 150,070 | 134,270 | ||
| Finished goods inventory, December 31 | 157,180 | (d) | ||
| Sales | 1,308,910 | 1,198,800 | ||
| Cost of goods sold | (d) | 775,620 | ||
| Gross profit | (e) | (e) | ||
| Operating expenses | 170,500 | (f) | ||
| Net income | (f) | 266,130 | ||
Required:
1. Determine the amounts of the missing items, identifying them by letter. Enter all amounts as positive numbers.
| Letter | On Company | Off Company |
| a. | $ | $ |
| b. | $ | $ |
| c. | $ | $ |
| d. | $ | $ |
| e. | $ | $ |
| f. | $ | $ |
2. Prepare On Company's statement of cost of goods manufactured for December.
| On Company | |||
| Statement of Cost of Goods Manufactured | |||
| For the Month Ended December 31 | |||
| Work in process inventory, December 1 | $ | ||
| Direct materials: | |||
| Materials inventory, December 1 | $ | ||
| Purchases $ | |||
| Cost of materials available for use | $ | ||
| Less materials inventory, December 31 $ | |||
| Cost of direct materials used in production | $ | ||
| Direct labor $ | |||
| Factory overhead $ | |||
| Total manufacturing costs incurred during December $ | |||
| Total manufacturing costs | $ | ||
| Less work in process inventory, December 31 $ | |||
| Cost of goods manufactured | $ | ||
3. Prepare On Company's income statement for December.
| On Company | ||
| Income Statement | ||
| For the Month Ended December 31 | ||
| Sales | $ | |
| Cost of goods sold: | ||
| Finished goods inventory, December 1 | $ | |
| Cost of goods manufactured $ | ||
| Cost of finished goods available for sale | $ | |
| Less finished goods inventory, December 31 $ | ||
| Cost of goods sold $ | ||
| Gross profit | $ | |
| Operating expenses $ | ||
| Net income | $ | |
In: Accounting
In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail.
JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are charged to jobs by using a predetermined overhead application rate. Clients are billed for directly chargeable costs, over-head, and a markup.JLR’s director of cost management, Brent Dean, anticipates the following costs for the upcoming year:
Percentage of Cost Directly Traceable to
ClientsProfessional staff salaries ...............................$2,500,000 ....................................80%
Administrative support staff ............................ 300,000 .................................................60%
Travel ............................................................... 250,000 ..................................................90%
Photocopying .................................................. 50,000 ................................................90%
Other operating costs ..................................... 100,000 ....................................50%
Total .............................................................$3,200,000
The firm’s partners desire to make a $640,000 profit for the firm and plan to add a percentage markup on total cost to achieve that figure.On March 10, JLR completed work on a project for Martin Manufacturing. The following costs were incurred: professional staff salaries, $41,000; administrative support staff, $2,600; travel, $4,500; photocopying, $500; and other operating costs, $1,400.
Questions Required:
Required: 1. Determine JLR’s total traceable costs for the upcoming year and the firm’s total anticipated overhead? 2. Calculate the predetermined overhead rate. The rate is based on total costs traceable to client jobs. 3. What percentage of cost will JLR add to each job to achieve its profit target? 4. Determine the total cost of the Martin Manufacturing project. How much would Martin be billed for services performed? 5. Notice that only 50 percent of JLR’s other operating cost is directly traceable to specific client projects. Cite several costs that would be included in this category and difficult to trace to clients. 6. Notice that 80 percent of the professional staff cost is directly traceable to specific client projects. Cite several reasons that would explain why this figure isn’t 100 percent.
In: Accounting
Cain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information.
The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were:
| Cost Pools | Costs | Activity Drivers | |
| Receiving | $ | 2,536,800 | Direct material cost |
| Manufacturing | 18,816,000 | Machine-hours | |
| Machine setup | 1,612,800 | Production runs | |
| Shipping | $ | 3,780,000 | Units shipped |
In this particular area, Cain produces two of its many products: Standard and Deluxe. The following are data for production for the latest full year of operations:
| Products | ||||||
| Standard | Deluxe | |||||
| Total direct material costs | $ | 976,500 | $ | 609,000 | ||
| Total direct labor costs | $ | 1,764,000 | $ | 1,029,000 | ||
| Total machine-hours | 441,000 | 399,000 | ||||
| Total number of setups | 189 | 315 | ||||
| Total pounds of material | 31,500 | 39,900 | ||||
| Total direct labor-hours | 18,900 | 10,500 | ||||
| Number of units produced and shipped | 63,000 | 21,000 | ||||
The intern decides to look more closely at the manufacturing activity and determines that it can be broken down into two activities: production and engineering. Production covers the costs of ongoing manufacturing while engineering includes those activities dealing with engineering changes, design modifications, and so on.
The costs attributed to production are $13,020,000 and the costs attributed to engineering are $5,796,000. After discussion with plant engineers, the intern decides that the best cost driver for engineering is setups, because most of the work arises from changes in the way the product is run.
Required:
1. Compute the totals of the cost driver rates shown below. (Round intermediate calculations and "Manufacturing" answer to 2 decimal places.)
2. What unit product costs will be reported for the two products if the revised ABC system is used?
In: Accounting
Ali is a student at the University. He recently
purchased a car for OMR5,000 to use it for going to the University.
Ali also expects that other friends might ask for transportation
from him. He expects a total monthly revenue of OMR50. He expects
fuel cost to be OMR40 per month. One of Ali's friends is a taxi
driver. He offered Ali to take him to University for a monthly fee
of OMR10. Because he does not have to drive, Ali believes that he
can perform online work that would earn him a monthly revenue of
OMR30. What is the differential revenue in this scenario? Select
one: O a. OMR40 O b. OMR50 O c. OMR20 O d. OMR10 O e. OMR30
2.The total prime cost of a product was OMR5,200. The variable
manufacturing overhead is calculated based on the number of direct
labor hours. The variable manufacturing overhead cost per hour is
four times the direct labor cost per hour. The fixed manufacturing
overhead was OMR2,000. Assuming that direct labor hours were 350
and that the direct labor cost was 30% of direct materials cost,
how much is the total manufacturing cost? Select one: O a.
OMR12,000 O b. OMR18,000 c. OMR7,200 O d. OMR26,000 O e.
OMR28,000
In: Accounting
Superior Micro Products uses the weighted-average method in its process costing system. During January, the Delta Assembly Department completed its processing of 25,100 units and transferred them to the next department. The cost of beginning work in process inventory and the costs added during January amounted to $708,310 in total. The ending work in process inventory in January consisted of 4,000 units, which were 50% complete with respect to materials and 30% complete with respect to labor and overhead. The costs per equivalent unit for the month were as follows:
| Materials | Labor | Overhead | |
| Cost per equivalent unit | $14.20 | $4.20 | $8.10 |
Required:
1. Compute the equivalent units of materials, labor, and overhead in the ending work in process inventory for the month.
2. Compute the cost of ending work in process inventory for materials, labor, overhead, and in total for January.
3. Compute the cost of the units transferred to the next department for materials, labor, overhead, and in total for January.
4. Prepare a cost reconciliation for January. (Note: You will not be able to break the cost to be accounted for into the cost of beginning work in process inventory and costs added during the month.)
I have tried to work through this on my own, I am looking for help on how to solve this problem. Thanks!
In: Finance
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:
| Date | Transaction | Number of Units |
Per Unit | Total | ||||
| Apr. 3 | Inventory | 72 | $225 | $16,200 | ||||
| 8 | Purchase | 144 | 270 | 38,880 | ||||
| 11 | Sale | 96 | 750 | 72,000 | ||||
| 30 | Sale | 60 | 750 | 45,000 | ||||
| May 8 | Purchase | 120 | 300 | 36,000 | ||||
| 10 | Sale | 72 | 750 | 54,000 | ||||
| 19 | Sale | 36 | 750 | 27,000 | ||||
| 28 | Purchase | 120 | 330 | 39,600 | ||||
| June 5 | Sale | 72 | 790 | 56,880 | ||||
| 16 | Sale | 96 | 790 | 75,840 | ||||
| 21 | Purchase | 216 | 360 | 77,760 | ||||
| 28 | Sale | 108 | 790 | 85,320 | ||||
Required:
1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.
2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account.
In: Accounting