Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sensory Boards Inc is preparing its budget for the third quarter of 2021 (July to September). The company has gathered information from its managers in

image text in transcribedimage text in transcribed

Sensory Boards Inc is preparing its budget for the third quarter of 2021 (July to September). The company has gathered information from its managers in preparation of the budgeting process. Sales 112,500 102,100 Unit sales for May 2021 Unit sales for June 2021 Expected unit sales for July 2021 Expected unit sales for August 2021 Expected unit sales for September 2021 Expected unit sales for October 2021 Expected unit sales for November 2021 Unit selling price 113,000 112,500 116,000 125,000 137,500 $12 The company likes to keep 10% of the next month's unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on June 30, 2021, totaled $183,780. Direct Materials Direct materials cost $0.75 per pound. Two pounds of direct materials are required to produce each unit. Sensory Boards likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on June 30, 2021 totaled 11,295 pounds. Desired ending direct materials on September 30, 2021 is 12,625 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on June 30, 2021, totaled $120,595. Direct Labor Labor requires 12 minutes per unit for completion and is paid at a rate of $8 per hour. Manufacturing Overhead Indirect materials Indirect labor Utilities Maintenance Salaries Depreciation Property taxes Insurance Janitorial 304 per labor hour 50e per labor hour 45e per labor hour 25e per labor hour $42,000 per month $16,800 per month $ 2,675 per month $ 1,200 per month $ 1,300 per month Selling and Administrative Variable selling and administrative cost per unit is $1.60. Fixed selling and administrative costs are as follows: Advertising Insurance Salaries Depreciation Other fixed costs $15,000 a month $ 1,400 a month $72,000 a month $ 2,500 a month $ 3,000 a month Required: For the third quarter of 2021 (July to September), prepare the following in proper form: a) Sales budget. 3 Marks b) Production budget. 6 Marks c) Direct materials budget. (Round to nearest dollar) 8 Marks d) Direct labor budget. (For calculations, round to the nearest hour) 6 Marks e) Manufacturing overhead budget. (Round amounts to the nearest dollar) 9 Marks f) Selling and administrative budget. 6 Marks g) Schedule for expected cash collections from customers. 6 Marks h) Schedule for expected payments for materials purchases. (Round totals to nearest dollar) 6 Marks Totals by quarter are not necessary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

8-6 Who poses the biggest security threat: insiders or outsiders?

Answered: 1 week ago