Questions
The beginning inventory at Midnight Supplies and data on purchases and sales for a three month...

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
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
131 Notes Receivable
132 Interest Receivable
141 Inventory
145 Office Supplies
146 Store Supplies
151 Prepaid Insurance
181 Land
191 Office Equipment
192 Accumulated Depreciation-Office Equipment
193 Store Equipment
194 Accumulated Depreciation-Store Equipment
LIABILITIES
210 Accounts Payable
221 Notes Payable
222 Interest Payable
231 Salaries Payable
241 Sales Tax Payable
EQUITY
310 Common Stock
311 Retained Earnings
312 Dividends
REVENUE
410 Sales
610 Interest Revenue
EXPENSES
510 Cost of Goods Sold
515 Credit Card Expense
516 Cash Short and Over
520 Salaries Expense
531 Advertising Expense
532 Delivery Expense
533 Insurance Expense
534 Office Supplies Expense
535 Rent Expense
536 Repairs Expense
537 Selling Expenses
538 Store Supplies Expense
561 Depreciation Expense-Office Equipment
562 Depreciation Expense-Store Equipment
590 Miscellaneous Expense
710 Interest Expense

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...

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
Customer Jackson Consulting Date October 1
Date wanted October 10
Date completed October 10
Job. No.
ESTIMATE
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...

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

  1. 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.

  2. 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...

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

  1. 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.

  2. 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...


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...

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,...

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...

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...

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...

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