Question

In: Accounting

Required information The Foundational 15 (Algo) [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] Skip to question...

Required information
The Foundational 15 (Algo) [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10]
Skip to question
[The following information applies to the questions displayed below.]

Morganton Company makes one product and it provided the following information to help prepare the master budget:

The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 9,400, 25,000, 27,000, and 28,000 units, respectively. All sales are on credit.
Thirty percent of credit sales are collected in the month of the sale and 70% in the following month.
The ending finished goods inventory equals 20% of the following month’s unit sales.
The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of finished goods requires 4 pounds of raw materials. The raw materials cost $2.50 per pound.
Twenty percent of raw materials purchases are paid for in the month of purchase and 80% in the following month.
The direct labor wage rate is $15 per hour. Each unit of finished goods requires two direct labor-hours.
The variable selling and administrative expense per unit sold is $2.00. The fixed selling and administrative expense per month is $64,000.

1. What are the budgeted sales for July?

2. What are the expected cash collections for July?

3. What is the accounts receivable balance at the end of July?

4. According to the production budget, how many units should be produced in July?

5. If 108,800 pounds of raw materials are needed to meet production in August, how many pounds of raw materials should be purchased in July?

6. If 108,800 pounds of raw materials are needed to meet production in August, what is the estimated cost of raw materials purchases for July?

7. In July what are the total estimated cash disbursements for raw materials purchases? Assume the cost of raw material purchases in June is $138,080; and $108,800 pounds of raw materials are needed to meet production in August.

8. If 108,800 pounds of raw materials are needed to meet production in August, what is the estimated accounts payable balance at the end of July?

9. If 108,800 pounds of raw materials are needed to meet production in August, what is the estimated raw materials inventory balance at the end of July?

10. What is the total estimated direct labor cost for July?

11. If we assume that there is no fixed manufacturing overhead and the variable manufacturing overhead is $10 per direct labor-hour, what is the estimated unit product cost? (Round your answer to 2 decimal places.)

12. If we assume that there is no fixed manufacturing overhead and the variable manufacturing overhead is $10 per direct labor-hour, what is the estimated finished goods inventory balance at the end of July?

13. If we assume that there is no fixed manufacturing overhead and the variable manufacturing overhead is $10 per direct labor-hour, what is the estimated cost of goods sold and gross margin for July?

14. What is the estimated total selling and administrative expense for July?

15. If we assume that there is no fixed manufacturing overhead and the variable manufacturing overhead is $10 per direct labor-hour, what is the estimated net operating income for July?

Solutions

Expert Solution


Related Solutions

The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the...
The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 8,400, 10,000, 12,000, and 13,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and...
The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the...
The Foundational 15 [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,700, 18,000, 20,000, and 21,000 units, respectively. All sales are on credit. b. Forty percent of credit sales are collected in the month of the...
Required information Problem 8-5 (Algo) Various inventory costing methods [LO8-1, 8-4] Skip to question [The following...
Required information Problem 8-5 (Algo) Various inventory costing methods [LO8-1, 8-4] Skip to question [The following information applies to the questions displayed below.] Ferris Company began January with 7,000 units of its principal product. The cost of each unit is $6. Merchandise transactions for the month of January are as follows: Purchases Date of Purchase Units Unit Cost* Total Cost Jan. 10 6,000 $ 7 $ 42,000 Jan. 18 7,000 8 56,000 Totals 13,000 98,000 * Includes purchase price and...
Problem 8-31 (Algo) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an...
Problem 8-31 (Algo) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 59,000 Accounts receivable 215,200 Inventory 60,600 Buildings and equipment (net) 369,000 Accounts payable $...
Required information Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question...
Required information Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question [The following information applies to the questions displayed below.] James Company began the month of October with inventory of $16,000. The following inventory transactions occurred during the month: The company purchased merchandise on account for $23,500 on October 12. Terms of the purchase were 2/10, n/30. James uses the net method to record purchases. The merchandise was shipped f.o.b. shipping point and freight charges...
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-9, LO8-10] Skip...
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-9, LO8-10] Skip to question [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 84,000 Accounts receivable 144,000 Inventory 63,750 Plant and equipment, net of depreciation 223,000...
Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] Skip to question [The following...
Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] Skip to question [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 121,600 $ 190,000 Purchases 520,000 708,000 $ 630,000 $ 1,056,000 Purchase returns 2,500 5,000 3,000 3,600 Freight-in 4,200 6,000...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the questions displayed below.] Diego Company manufactures one product that is sold for $77 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 48,000 units and sold 43,000 units. Variable costs per unit: Manufacturing: Direct materials $ 27 Direct labor $ 12 Variable manufacturing overhead $ 3 Variable selling...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the questions displayed below.] Diego Company manufactures one product that is sold for $70 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 53,000 units and sold 48,000 units. Variable costs per unit: Manufacturing: Direct materials $ 21 Direct labor $ 10 Variable manufacturing overhead $ 2 Variable selling...
Required information The Foundational 15 [LO12-2, LO12-3, LO12-4, LO12-5, LO12-6] [The following information applies to the...
Required information The Foundational 15 [LO12-2, LO12-3, LO12-4, LO12-5, LO12-6] [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $120 and $80, respectively. Each product uses only one type of raw material that costs $6 per pound. The company has the capacity to annually produce 100,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT