Question

In: Accounting

Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the...

Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month’s sales are in the current month’s finished goods inventory. Ingles also purchases sufficient materials to ensure that the current month’s ending materials inventory is 60 percent of the following month’s direct materials required for production. Ingle’s sales budget in units for the next quarter is as follows:

The cost of each table leg is $10

The tables to be produced in September are 2,100 (the same as the units sold for that month)

July........................................................................................................ 2,450

August.................................................................................................. 2,900

September............................................................................................. 2,100

Ingle’s ending inventories in units for July 31 are as follows:

Finished goods...................................................................................... 1,900

Materials (legs)...................................................................................... 4,000

Requirements:

Prepare Ingle’s production budget for tables in August.

Prepare Ingle’s August direct materials purchases budget for table legs.

How many employees will be required for the Assembly Department in August?Fractional employees are acceptable since employees can be hired on a part-time basis.Assume a 40-hour week and a 4-week month.

Solutions

Expert Solution

Ingle’s production budget for tables in August
A B C
S.no Particulars July August September
1 Budgeted Production 2,450.00     2,900.00    2,100.00
Opening Stock
2 Finished Goods 1,900.00     1,160.00       840.00
3=1-2 Produce for current month       550.00     1,740.00    1,260.00
4=1C*40% Produce for next month 1,160.00        840.00                -  
Production 1,710.00     2,580.00    1,260.00
Ingle’s August direct materials purchases budget for table legs
A B C
S.no Particulars July August September
Purchases
1 Required for current month 6,840.00 10,320.00    5,040.00
2 Opening stock (4,000.00) (1,740.00) (1,260.00)
3=1C*60% For next month production 6,192.00     3,024.00

               -  

Note:- For Knowing Required legs for current month, we have to multiply with 4 to the production of the month.

Employees required for assembling department for the month of August

Production for a month by each labour = (40 hours * 60 minutes * 4 weeks) / 16 minutes = 600 chairs

Total production required = 2580

Number of employees required = 2580 / 600 = 4.3 labours


Related Solutions

Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the...
Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month’s sales are in the current month’s finished goods inventory. Ingles also purchases sufficient materials...
Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the...
Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month’s sales are in the current month’s finished goods inventory. Ingles also purchases sufficient materials...
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The...
Ingles Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month's sales are in the finished goods...
For this assignment you have to create tables as reviewed in class Manufacturer table, Product table...
For this assignment you have to create tables as reviewed in class Manufacturer table, Product table and Stock table. The code is in Week 7 PPT lecture. You are to add update as needed to make the tables the same as below and match Product, Manufacturer and Stock as below. For this assignment you will be working with these same tables.   Please complete the following tasks and submit in word file or notepad. 1. First insert tuples into two of...
For this assignment you have to create tables as reviewed in class Manufacturer table, Product table...
For this assignment you have to create tables as reviewed in class Manufacturer table, Product table and Stock table. The code is in Week 7 PPT lecture. You are to add update as needed to make the tables the same as below and match Product, Manufacturer and Stock as below. For this assignment you will be working with these same tables.   Please complete the following tasks and submit in word file or notepad. 1. First insert tuples into two of...
*Merriweather Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The...
*Merriweather Corporation is a manufacturer of tables sold to schools, restaurants, hotels, and other institutions. The table tops are manufactured by Merriweather, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 20 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40% of next month's sales are in the finished goods inventory....
Table Rock Tables, manufactures two popular tables, a country style table and a contemporary style table....
Table Rock Tables, manufactures two popular tables, a country style table and a contemporary style table. The manufacturing process for both tables requires the use of three types of machines. The time to produce the tables on each machine given in the following table: Machine   Country Table Contemporary Table Total Time Available Router 1.5 2 1000 Sander 3.0 4.5 2000 Polisher 2.5 1.5 1500 The earns a profit of $350 on the Country table, and $450 on the Contemporary table....
Tables: Create table Item(    &nbs... Bookmark Tables: Create table Item(                 ItemId           &nb
Tables: Create table Item(    &nbs... Bookmark Tables: Create table Item(                 ItemId                 char(5) constraint itmid_unique primary key,                 Decription           varchar2(30),                 Unitcost               number(7,2)); Create table Customer(                 custID                   char(5) constraint cid.unique primary key,                 custName          varchar2(20),                 address                                varchar2(50)); Create table Orderdata( orderID                char(5) constraint oid_uniq primary key,                 orderdate           date,                 shipdate              date,                 ItemId                  char(5) references Item.ItemId,                 No_of_items     number(4),                 Unitcost               number(7,2),                 Order_total        number(7,2),                 custID                   char(5) references customer.custID); Insert Into Item values(‘A123’,’Pencil’,2.5);...
A furniture manufacturer specializes in wood tables. The tables sell for $ 140 per unit and...
A furniture manufacturer specializes in wood tables. The tables sell for $ 140 per unit and incur $ 49 per unit in variable costs. The company has $ 14,560 in fixed costs per month. The company desires to earn an operating profit of $ 8,190 per month. ​(Abbreviation used; CM​ = contribution​ margin.) 10. Calculate the required sales in units to earn the target profit using the equation method. 11. Calculate the required sales in units to earn the target...
Tops Corporation is organized into two divisions, Manufacturing and Marketing. Both divisions are considered to be...
Tops Corporation is organized into two divisions, Manufacturing and Marketing. Both divisions are considered to be profit centers and the two division managers are evaluated in large part on divisional income. The company makes a single product. It is fabricated in Manufacturing and then packaged and sold in Marketing. There is no intermediate market for the product. The monthly income statements, in thousands of dollars, for the two divisions follow. Production and sales amounted to 10,000 units. Manufacturing Marketing Revenues...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT