Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods sold to equal 70% of sales. Its inventory policy calls for ending inventory at the end of each month to equal 20% of the next month’s budgeted cost of goods sold. All purchases are on credit, and 25% of the purchases in a month is paid for in the same month. Another 60% is paid for during the first month after purchase, and the remaining 15% is paid for in the second month after purchase. The following sales budgets are set: July, \(350,000; August, \)290,000; September, \(320,000; October, \)275,000; and November, $265,000.

Compute the following:

(1) budgeted merchandise purchases for July, August, September, and October;

(2) budgeted payments on accounts payable for September and October; and

(3) budgeted ending balances of accounts payable for September and October. (Hint: For part 1, refer to Exhibits 20A.2 and 20A.3 for guidance, but note that budgeted sales are in dollars for this assignment.)

Short Answer

Expert verified

Accounts payable is a term used to define the amount owned by an organization from its creditors during the period of an accounting year.

Step by step solution

01

(1) Budgeted merchandise purchases

Big Sound
Budgeted merchandise purchases
For the month of July, August, September and October

Particulars

July

August

September

October

Cost of goods sold @70% of sales

$245,000

$203,000

$224,000

$192,500

Add: Ending inventory

$40,600

$44,800

$38,500

$37,100

Inventory available

$285,600

$247,800

$262,500

$229,600

Less: Beginning inventory

$49,000

$40,600

$44,800

$38,500

Required purchases

$236,600

$207,200

$217,700

$191,100

02

(2) Budgeted payment on accounts payable

Big Sound
Budgeted payment on accounts payable
For the month of September and October

Particulars

Purchases

September

October

July purchases

$236,600

$35,490

August purchases

$207,200

$124,320

$31,080

September purchases

$217,700

$54,425

$130,620

October purchases

$217,700

$54,425

Total

$214,235

$216,125

03

(3) Budgeted ending balances

Big Sound
Budgeted ending balances
For the month of September

Particulars

Purchases

Percentage unpaid as of September

Amount unpaid as of September

July purchases

$236,600

0%

August purchases

$207,200

15%

$31,080

September purchases

$217,700

75%

$163,275

September 30 budgeted accounts payable

$194,355

Big Sound

Budgeted ending balances

For the month of September

Particulars

Purchases

Percentage unpaid as of September

Amount unpaid as of September

July purchases

$236,600

0%

August purchases

$207,200

0%

September purchases

$217,700

15%

$32,655

October purchases

$191,100

75%

$143,325

October 31 budgeted accounts payable

$175,980


Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Black Diamond Company produces snow skis. Each ski requires 2 pounds of carbon fiber. The company’s management predicts that 5,000 skis and 6,000 pounds of carbon fiber will be in inventory on June 30 of the current year and that 150,000 skis will be sold during the next (third) quarter. A set of two skis sells for \(300. Management wants to end the third quarter with 3,500 skis and 4,000 pounds of carbon fiber in inventory. Carbon fiber can be purchased for \)15 per pound. Each ski requires 0.5 hours of direct labor at \(20 per hour. Variable overhead is applied at the rate of \)8 per direct labor hour. The company budgets fixed overhead of $1,782,000 for the quarter.

Required

1. Prepare the third-quarter production budget for skis.

2. Prepare the third-quarter direct materials (carbon fiber) budget; include the dollar cost of purchases.

3. Prepare the direct labor budget for the third quarter.

4. Prepare the factory overhead budget for the third quarter.

Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year.

According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of \(30,000 at each month-end. In return, the bank has agreed that the company can borrow up to \)150,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of \(30,000 on the last day of each month. The company has a cash balance of \)30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March.

Coca-Cola recently redesigned its bottle to reduce its use of glass, thus lowering its bottle’s weight and CO2 emissions. Which budgets in the company’s master budget will this redesign impact?

The production budget for Manner Company shows units to be produced as follows: July, 620; August, 680; and September, 540. Each unit produced requires two hours of direct labor. The direct labor rate is currently \(20 per hour but is predicted to be \)21 per hour in September. Prepare a direct labor budget for the months July, August, and September.

Question: Merline Manufacturing makes its product for \(75 per unit and sells it for \)150 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows.

Management expects December’s results to be repeated in January, February, and March of 2018 without any changes in strategy. Management, however, has an alternative plan. It believes that unit sales will increase at a rate of 10% each month for the next three months (beginning with January) if the item’s selling price is reduced to \(125 per unit and advertising expenses are increased by 15% and remain at that level for all three months. The cost of its product will remain at \)75 per unit, the sales staff will continue to earn a 10% commission, and the remaining expenses will stay the same.

Required

  1. Prepare budgeted income statements for each of the months of January, February, and March that show the expected results from implementing the proposed changes. Use a three-column format, with one column for each month.

Analysis Component

  1. Use the budgeted income statements from part 1 to recommend whether management should implement the proposed changes. Explain.
See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free