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

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,500 $70.00 $175,000
10 Purchase 8,000 78.00 624,000
28 Sale 3,800 140.00 532,000
30 Sale 1,250 140.00 175,000
Feb. 5 Sale 500 140.00 70,000
10 Purchase 17,000 80.00 1,360,000
16 Sale 9,100 145.00 1,319,500
28 Sale 8,700 145.00 1,261,500
Mar. 5 Purchase 14,300 81.60 1,166,880
14 Sale 9,800 145.00 1,421,000
25 Purchase 3,000 82.00 246,000
30 Sale 7,900 145.00

1,145,500

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

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 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 inventory using the last-in, first-out method to be higher or lower?

chart of accounts ensure to use the exact lables

CHART OF ACCOUNTS
Midnight Supplies
General Ledger
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
131 Notes Receivable
132 Interest Receivable
141 Merchandise 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 Owner, Capital
311 Owner, Drawing
312 Income Summary
REVENUE
410 Sales
610 Interest Revenue
EXPENSES
510 Cost of Merchandise 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 merchandise sold data in a perpetual inventory record similar to the one illustrated in

Exhibit 3

, using the first-in, first-out method.

Date Purchases Cost of Merchandise Sold Inventory
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

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 inventory using the last-in, first-out method to be higher or lower?

Lower

Higher

In: Accounting

1. Flexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office...

1. Flexible Budget for Assembly Department

Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:

Direct labor per filing cabinet 30 minutes
Supervisor salaries $123,000 per month
Depreciation $16,000 per month
Direct labor rate $18 per hour

Prepare a flexible budget for 10,000, 13,000, and 15,000 filing cabinets for the month of March in the Assembly Department similar to Exhibit 5. Enter all amounts as positive numbers.

Cabinaire Inc.
Assembly Department Budget
Month Ending March 31 (assumed data)
Units of production 10,000 13,000 15,000
Variable cost:
$ $ $
Total variable cost $ $ $
Fixed cost:
$ $ $
Total fixed cost $ $ $
Total department costs $ $ $

2.

Production Budget

Weightless Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows:

Bath Scale Gym Scale
East Region unit sales 23,800 36,900
West Region unit sales 25,700 27,000
Total 49,500 63,900

The finished goods inventory estimated for October 1, for the Bath and Gym scale models is 1,800 and 2,600 units, respectively. The desired finished goods inventory for October 31 for the Bath and Gym scale models is 1,300 and 2,800 units, respectively.

Prepare a production budget for the small and large scales for the month ended October 31. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Weightless Inc.
Production Budget
For the Month Ending October 31
Units Bath Scale Units Gym Scale
Total
Total units to be produced

3.

Sales and Production Budgets

Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget:

Rumble Thunder
Estimated inventory (units), June 1 288 84
Desired inventory (units), June 30 331 73
Expected sales volume (units):
Midwest Region 3,750 3,300
South Region 5,700 6,450
Unit sales price $130 $200

a. Prepare a sales budget.

Sonic Inc.
Sales Budget
For the Month Ending June 30
Product and Area Unit Sales Volume Unit Selling Price Total Sales
Model: Rumble
Midwest Region $ $
South Region
Total $
Model: Thunder
Midwest Region $ $
South Region
Total $
Total revenue from sales $

b. Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Sonic Inc.
Production Budget
For the Month Ending June 30
Units Rumble Units Thunder
Total
Total units to be produced

In: Accounting

Market Forms The following questions address some of the price and output decisions faced by firms...

Market Forms

The following questions address some of the price and output decisions faced by firms other than those found in perfect competition. Some numbers may be rounded.

Table 1-a

Average Fixed cost

Average Variable Cost

Average Total Cost

Output

0

1

$   180.00

$ 135.00

$    315.00

2

$     90.00

$ 127.50

$    217.50

3

$     60.00

$ 120.00

$    180.00

4

$     45.00

$ 112.50

$    157.50

5

$     36.00

$ 111.00

$    147.00

6

$     30.00

$ 112.50

$    142.50

7

$     25.71

$ 115.70

$    141.41

8

$     22.50

$ 121.90

$    144.40

9

$     20.00

$ 130.00

$    150.00

10

$     18.00

$ 139.50

$    157.50

Table 1-a (continued)

Marginal Cost

Price

Total Revenue

Marginal Revenue

Output

0

$ 345.00

1

$ 300.00

2

$ 249.00

3

$ 213.00

4

$ 189.00

5

$ 165.00

6

$ 144.00

7

$ 126.00

8

$ 111.00

9

$   99.00

10

$   87.00

Questions:

  1. Complete Table 1. Summarize your calculations and use Microsoft Excel.
  2. Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.
  3. Using the data in the table and on your graph, what is the profit maximizing, or loss minimizing level of output? Explain and justify your answers.
  4. What is a normal profit? What is an economic profit? Explain your answer using examples. Are normal profits being earned in this example? Are economic profits present for this firm in this example? Explain your answers.
  5. Given the data in the table and the graph, how could you determine or identify the optimal plant size?
  6. What is the difference between explicit and implicit cost? Explain your answers.
  7. How would we determine if a cost is a fixed cost or a variable cost?

In: Economics

A manufacturer of base units for home sensor protection (security, water, carbon monoxide, etc.) produces these...

  1. A manufacturer of base units for home sensor protection (security, water, carbon monoxide, etc.) produces these units in a small facility in northern Indiana. The firm’s engineer has set up “assembly cells” in the facility that she believes will be the most efficient means of producing the units. The following table displays the various costs per hour for producing the units.

Outputs per hour Total Cost Fixed Cost Variable Cost Avg Total Cost Avg Fixed Cost Avg Var Cost Marg Cost

0 $100 $100 $30

1 $130 $100 $30 $130    $100 30 $28

2 $158 $100 $58 $79 $50 $29 $25

3 $183 $100 $83 $61 $33.33 $27.67 $21

4 $204 $100 $104 $51 $25 $26.00 $18

5 $222 $100 $122 $44.40 $20 $24.40 $20

6 $242 $100 $142 $40.33 $16.67 $23.67 $23

7 $265 $100 $165 $37.86 $14.29 $23.57 $30

8 $295 $100 $195 $36.88 $12.50 $24.38 $38

9 $333 $100 $233 $37 $11.11 $25.89 $40

10 $373 $100 $273 $37.30 $10.00 $27.30

  1. Explain why Average Total Costs (ATC) declines through the production quantities. Only with the tenth unit per hour does the firm see a minor increase in ATC.
  2. Explain why Average Fixed Cost (AFC) declines across all levels of production. What do you call this phenomenon?
  3. Explain why Marginal Costs initially decline but then increase with the sixth unit of production. Which short run production principle is at work here in creating this pattern of Marginal Costs?

In: Economics

The Barberton Municipal division of Road Maintenance is charged with road repair in the city of...

The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the surrounding area. Cindy​ Kramer, road maintenance​ director, must submit a staffing plan for the next year based on a set schedule for repairs and on the city budget. Kramer estimates that the labor hours required for the next four quarters are 7,000​, 12,000​, 19,500​, and 9,000​, respectively. Each of the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an overtime pay rate of $ 17 for each overtime hour. Overtime is limited to 20 percent of the​ regular-time capacity in any quarter. Although unused overtime capacity has no​ cost, unused regular time is paid at $ 12 per hour. The cost of hiring a worker is $4,000​, and the cost of laying off a worker is $2,000.

Subcontracting is not permitted. ​(Hint: When calculating the number of​ workers, make sure to round up to the next whole number before proceeding with any further​ calculations.)

a. Find a level workforce plan that relies just on overtime and the minimum amount of undertime possible. Overtime can be used to its limits in any quarter. What is the total cost of the​ plan?

b. Use a chase strategy that varies the workforce level without using overtime or undertime. What is the total cost of this​ plan?

c.

. Consider the following proposed​ plan, for a different demand​ schedule, that combines the strategy of​ hiring, layoffs, and utilizing overtime. Payroll costs are

$6,000

in wages per worker for regular time​ worked, with an overtime pay rate of

$ 17

for each overtime hour. The cost of hiring a worker is

$4,000

and the cost of laying off a worker is

$2,000.

The total cost for this plan would be

​(Enter your response as an​ integer.)

In: Accounting

During the first month of operations ended August 31, Kodiak Fridgeration Company manufactured 40,000 mini refrigerators,...

During the first month of operations ended August 31, Kodiak Fridgeration Company manufactured 40,000 mini refrigerators, of which 36,000 were sold. Operating data for the month are summarized as follows:

1

Sales

$8,280,000.00

2

Manufacturing costs:

3

Direct materials

$2,800,000.00

4

Direct labor

1,200,000.00

5

Variable manufacturing cost

800,000.00

6

Fixed manufacturing cost

440,000.00

5,240,000.00

7

Selling and administrative expenses:

8

Variable

$540,000.00

9

Fixed

216,000.00

756,000.00

Required:
1. Prepare an income statement based on the absorption costing concept.*
2. Prepare an income statement based on the variable costing concept.*
3. Explain the reason for the difference in the amount of income from operations reported in (1) and (2).

* Refer to the lists of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. Be sure to complete the statement heading. A colon (:) will automatically appear if required. Enter Inventory, August 31 as a negative number using a minus sign. If a net loss is incurred, enter that amount as a negative number using a minus sign.

Labels
August 31
Cost of goods sold
Fixed costs
For the Month Ended August 31
Variable cost of goods sold
Amount Descriptions
Contribution margin
Contribution margin ratio
Cost of goods manufactured
Fixed manufacturing costs
Fixed selling and administrative expenses
Gross profit
Income from operations
Inventory, August 31
Loss from operations
Manufacturing margin
Planned contribution margin
Sales
Sales mix
Selling and administrative expenses
Total cost of goods sold
Total fixed costs
Total variable cost of goods sold
Variable cost of goods manufactured
Variable selling and administrative expenses

In: Accounting

Green Furniture (GF) manufactures a variety of furniture for household use and just two items for...

Green Furniture (GF) manufactures a variety of furniture for household use and just two items for office use: desks and cabinets. The production process for desks and cabinets is similar, although machines must be retooled for each product. Both materials and labour costs are directly traceable to individual products; however, overhead is a common cost and allocated using direct labour-hours as the allocation base. GF’s accountant is considering the use of activity-based costing (ABC) and has suggested evaluating the system by applying it to the two office use products (desks and cabinets). The following data are available for a typical quarter.

Activity Cost Pool Activity Base Activity Rate Activity Usage
Desks Cabinets
Parts receipts Number of parts $ 2.00 per part 1,200 parts 800 parts
Machining Machine-hours $ 12.00 per machine-hour 120 machine-hours 180 machine-hours
Assembly Units produced $ 1.60 per unit 600 units 800 units
Quality control Units tested $ 3.00 per unit 60 units 700 units
Direct materials $ 3,000 $ 1,600
Direct labour $ 7,200 $ 7,200

Each product consumed 360 direct labour-hours.

Required:

1. Determine the total manufacturing cost and cost per unit for each of the two product lines for the quarter, using activity-based costing to allocate overhead costs. (Round "Cost per unit" answers to 2 decimal places.)

dusters cabinets
total manufacturing costs
cost per unit

2. Redo the above using direct labour-hours as the allocation base. (Round "Cost per unit" answers to 2 decimal places.)

Mops Dusters
total manufacturing costs
Cost per unit

In: Accounting

Butrico Manufacturing Corporation uses a standard cost system, records materials price variances when direct materials are...

Butrico Manufacturing Corporation uses a standard cost system, records materials price variances when direct materials are purchased, and prorates all variances at year-end. Variances associated with direct materials are prorated based on the balances of direct materials in the appropriate accounts, and variances associated with direct labor and manufacturing overhead are prorated to Finished Goods Inventory and to Cost of Goods Sold (CGS) on the basis of the relative direct labor cost in these accounts at year-end.

The following information is for the year ended December 31:

The company had no beginning inventories and no ending Work-in-Process (WIP) Inventory. It applies manufacturing overhead at 80% of standard direct labor cost.

Finished goods inventory at 12/31:
Direct materials $ 85,500
Direct labor 130,400
Applied manufacturing overhead 104,700
Direct materials inventory at 12/31 65,300
Cost of goods sold for the year ended 12/31:
Direct materials $ 352,100
Direct labor 740,600
Applied manufacturing overhead 592,500
Direct materials price variance (unfavorable) 11,100
Direct materials usage variance (favorable) 15,300
Direct labor rate variance (unfavorable) 19,900
Direct labor efficiency variance (favorable) 5,500
Actual manufacturing overhead incurred 691,300

Required:

1. Compute the amount of Direct Materials Price Variance to be prorated to Finished Goods Inventory at December 31.

2. Compute the total amount of direct materials cost in the Finished Goods Inventory at December 31, after all materials variances have been prorated.

3. Compute the total amount of direct labor cost in the Finished Goods Inventory at December 31, after all variances have been prorated.

4. Compute the total Cost of Goods Sold (CGS) for the year ended December 31, after all variances have been prorated.

In: Accounting

Bunnell Corporation is a manufacturer that uses job-order costing. On January 1, the company’s inventory balances...

Bunnell Corporation is a manufacturer that uses job-order costing. On January 1, the company’s inventory balances were as follows:

Raw materials $ 77,500
Work in process $ 32,800
Finished goods $ 34,800

The company applies overhead cost to jobs on the basis of direct labor-hours. For the current year, the company’s predetermined overhead rate of $12.75 per direct labor-hour was based on a cost formula that estimated $510,000 of total manufacturing overhead for an estimated activity level of 40,000 direct labor-hours. The following transactions were recorded for the year:

  1. Raw materials were purchased on account, $654,000.
  2. Raw materials use in production, $618,800. All of of the raw materials were used as direct materials.
  3. The following costs were accrued for employee services: direct labor, $460,000; indirect labor, $150,000; selling and administrative salaries, $270,000.
  4. Incurred various selling and administrative expenses (e.g., advertising, sales travel costs, and finished goods warehousing), $417,000.
  5. Incurred various manufacturing overhead costs (e.g., depreciation, insurance, and utilities), $360,000.
  6. Manufacturing overhead cost was applied to production. The company actually worked 41,000 direct labor-hours on all jobs during the year.
  7. Jobs costing $1,539,250 to manufacture according to their job cost sheets were completed during the year.
  8. Jobs were sold on account to customers during the year for a total of $3,172,500. The jobs cost $1,549,250 to manufacture according to their job cost sheets.

Required :

6. What is the journal entry to record the transfer of completed jobs that is referred to in item g above?

7. What is the ending balance in Work in Process?

8. What is the total amount of actual manufacturing overhead cost incurred during the year?

9. Is manufacturing overhead underapplied or overapplied for the year? By how much?

10. What is the cost of goods available for sale during the year?

In: Accounting

Part A Furniture Specialties is a company that make two types of dining tables: Simple and...

Part A

Furniture Specialties is a company that make two types of dining tables: Simple and Futuristic. There are two types of direct materials: Pine and Mahogany woods. Direct manufacturing labour workers are hired on an hourly basis; no overtime is worked. In terms of manufacturing overhead costs, there are two manufacturing overhead cost pools and two cost drivers. The two manufacturing overhead cost pools are manufacturing operations overhead and machine setup overhead. The cost drivers for manufacturing overhead are: direct manufacturing labour-hours for manufacturing operations overhead cost and setup labour-hours for machine setup overhead cost. Nonmanufacturing costs consist of product design, marketing, and distribution costs.

The following data are available for the 2018 budget:

Direct Materials Rate

Pine

$ 9 per meter square (m2)

Mahogany

$13 per meter square (m2)

Direct Manufacturing labour rate

$25 per hour

Quantity of Material for Each Product

Simple Table

Futuristic Table

Pine

14 m2

14 m2

Mahogany

8 m2

10 m2

Direct Material Labour

6 hours

8 hours

Products

Simple Table

Futuristic Table

Expected Sales for 2018 (in units)

55,000

15,000

Selling Price

$                 750

$              950

Target ending inventory in units

12,000

500

Beginning inventory in units

1,000

500

Beginning inventory in dollars

                  $          400,000

$       275,000

Direct materials inventory

Pine

Mahogany

Beginning inventory

85,000 m2

65,000 m2

Target ending inventory

90,000 m2

25,000 m2

Data on Manufacturing Overhead Cost

Manufacturing Operations Overhead cost (in capacity of 350,000 direct manufacturing labour-hours)

Variable manufacturing operation overhead costs (per direct manufacturing labour-hours)

Supplies

Indirect manufacturing labour

Power (support department costs)

Maintenance (support department costs)

Total variable manufacturing operation overhead cost

$                       4.50

6.50

7.00

                     3.50

$                     21.50

Fixed manufacturing operation overhead cost

Depreciation

Supervision

Power (support department costs)

Maintenance (support department costs)

Total fixed manufacturing operation overhead cost

$           1,400,000

420,000

725,000

                430,000

$           2,975,000

Machine Setup Overhead Costs (in capacity of 15,150 setup labour-hours)

Variable machine setup overhead cost (per setup labour-hours)

Supplies

Indirect manufacturing labour

Power (support department)

Total variable machine setup overhead cost

$                        25

55

                         10

$                       90

Fixed machine setup overhead cost

Depreciation

Supervision

Power (Support department cost)

Total fixed machine setup overhead cost

$             605,000

1,040,000

                  21,500

$         1,666,500

0.2 hour of setup labour-hour is allocated to make one unit of simple table and 0.3 hour of setup labour-hour is allocated for futuristic table

Non-manufacturing Cost

Product Design Cost (fixed)

$           1,100,000

Marketing Cost

Fixed marketing cost

Variable marketing cost is equals the 7.5% of revenues

$           1,350,000

Distribution Cost

Fixed distribution cost

Variable distribution cost is $2 per cubic feet of table sold and shipped

Simple table 20 cubic feet per table sold and shipped

Futuristic table 25 cubic feet per table sold and shipped

     $          1,700,000

Required:

Based on the above information provided by the various department managers, prepare the following budgets:

C. Direct Material Usage Budget in quantity and dollars (6 points)

In: Accounting