АВС СОМРANY Month Sales budget July August September 800,000 750,000 990,000 October 630,000 November 560,000 Other data: 1. Cost of Goods Sold is 65% of sales. 2. Total monthly fixed costs are 120,000, plus an additional 30,000 non-cash expenses. 3. The company maintains inventory two-month supply, which includes the following month. 4. ABC Co. pays for its purchases 45% in the month of purchase, 55% in the following month. 5. The company collects 75% of its sales in the month of sale, and 25% in the following month. 6. ABC Co. pays all other expenses requiring cash disbursements as incurred. 7. ABC Co. tries to keep at least 30,000 cash as buffer against unexpected needs. Balance Sheet as of 30 June 2022 Assets Liabilities and Capital 100,000 Cash Accounts Receivable Inventory Accounts Payable 200,000 280,000 490,000 Non-current asset 1,550,000 A, Capital 2,220,000 Total PHP 2,420,000 PHP 2,420,000 Pro Forma Balance Sheet as of 30 September 2022 Assets Liabilities and Capital Cash Accounts Payable Accounts Receivable Inventory Non-current asset | 4, Capital Total PHP 0 PHP 0

АВС СОМРANY Month Sales budget July August September 800,000 750,000 990,000 October 630,000 November 560,000 Other data: 1. Cost of Goods Sold is 65% of sales. 2. Total monthly fixed costs are 120,000, plus an additional 30,000 non-cash expenses. 3. The company maintains inventory two-month supply, which includes the following month. 4. ABC Co. pays for its purchases 45% in the month of purchase, 55% in the following month. 5. The company collects 75% of its sales in the month of sale, and 25% in the following month. 6. ABC Co. pays all other expenses requiring cash disbursements as incurred. 7. ABC Co. tries to keep at least 30,000 cash as buffer against unexpected needs. Balance Sheet as of 30 June 2022 Assets Liabilities and Capital 100,000 Cash Accounts Receivable Inventory Accounts Payable 200,000 280,000 490,000 Non-current asset 1,550,000 A, Capital 2,220,000 Total PHP 2,420,000 PHP 2,420,000 Pro Forma Balance Sheet as of 30 September 2022 Assets Liabilities and Capital Cash Accounts Payable Accounts Receivable Inventory Non-current asset | 4, Capital Total PHP 0 PHP 0

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 10PB: All Temps has a policy of always paying within the discount period, and each of its suppliers...

See similar textbooks

Related questions

Q: Assume a merchandising company’s estimated sales for January, February, and March are $106,000,…

A: Cash disbursements for February = (Budgeted purchases for January X 75%) + (Budgeted purchases for…

Q: Assume a merchandising company’s estimated sales for January, February, and March are $118,000,…

A: it is given that, It pays for 25% of its merchandise purchases in the month of the purchase and the…

Q: The following information pertains to Monroe Company: Month Sales Purchases January $62,000 $33,000…

A: Purchases may be made in cash or by credit. The credit purchases have to be paid for in the months…

Q: Rent Expense $9,000 per month Depreciation Expense $3,500 per month Insurance Expense $1,250 per…

A: The cash payments include the payments for prior periods and current period. The depreciation…

Q: Assume a merchandising company's estimated sales for January, February, and March are $105,000,…

Q: Assume a merchandising company’s estimated sales for January, February, and March are $105,000,…

A: The budget is prepared to estimate the future requirements in advance.

Q: Blossom, Inc. expects sales volume totaling $510000 for June. Data for the month follows: Sales…

A: The selling expense budget is prepared at the beginning of the period that includes the selling…

Q: Assume a merchandising company's estimated sales for January, February, and March are $106,000…

A: Solution:- Calculation of cash disbursements for February as follows:- Working note:-1…

Q: Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:…

Q: Alpha Company makes all its sales on account. The accounts receivable payment experience is as…

A: Budgeted cash collection is the expected cash is to be collected in a particular month for the…

Q: H ltd is preparing its budget for the second quarter. The following information is available…

Q: A company's data regarding its operations follow: 1. Sales budget November $360,000 December…

A: The net income is transferred from the income statement to the retained earnings.. Dividends are…

Q: Blue Spruce, Inc. provided the following information: March April May Projected…

A: Budgeted cash disbursement means the amount of expenses estimated to be paid in future period. This…

Q: Benton Company's sales budget shows the following expected total sales Month Sales January $20,ee0…

Q: ge Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected…

A: Cash Receipts from Customers is based on budgeted cash receipts that is estimated on specific…

Q: Digregory makes all purchases on account, subject to the following payment pattern: Paid in the…

A: Cost Accounting: It is the process of collecting, recording, analyzing the cost, summarizing cost,…

Q: Assume a merchandising company's estimated sales for January, February, and March are $107,000, $…

A: The budget is prepared to estimate the requirements for the period. The purchase budget is prepared…

Q: Corning Incorporated sells its product for $24 per unit. Its actual and projected sales follow:…

A: Purchases budget: This budget shows the expected purchase requirement of inventories for the…

Q: Matthew Company has a sales budget for last month of $400,000. Cost of goods sold is expected to be…

A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…

Q: Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are…

A: The objective of the question is to calculate the total cash receipts for Page Company in Month 4.…

Q: Bexon company sells a product for RM730. Unit sales for May were 700 and each month's sales are…

A: Sales budget is an operating budget and it was used by the organisation to find out the sales…

Q: Sheridan, Inc. expects sales volume totaling $460000 for June. Data for the month follows: Sales…

A: The selling expense budget includes all the selling expenses like sales commission, sales manager…

Q: Assume a manufacturing company,s estimated sales for january,febuar and march are 1,00,000 ,…

A: Cost of goods sold = Sales x 40% Purchases = Cost of goods sold + Desired ending inventory -…

Q: Kent Company has a sales budget for next month of $1,000,000. Cost of goods sold is expected to be…

A: Cost of goods sold is the total cost of units sold during the period. It is calculated as beginning…

Q: Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are…

A: Lets understand the basics.Budget: Budget is the process of identifying, collecting, and summarizing…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

АВС СОМРANY
Month
Sales budget
July
August
800,000
750,000
September
990,000
October
630,000
November
560,000
Other data:
1. Cost of Goods Sold is 65% of sales.
2. Total monthly fixed costs are 120,000, plus an additional 30,000 non-cash expenses.
3. The company maintains inventory two-month supply, which includes the following month.
4. ABC Co. pays for its purchases 45% in the month of purchase, 55% in the following month.
5. The company collects 75% of its sales in the month of sale, and 25% in the following month.
6. ABC Co. pays all other expenses requiring cash disbursements as incurred.
7. ABC Co. tries to keep at least 30,000 cash as buffer against unexpected needs.
Balance Sheet as of 30 June 2022
Assets
Liabilities and Capital
Cash
100,000
Accounts Payable
200,000
Accounts Receivable
280,000
Inventory
490,000
Non-current asset
1,550,000
A, Capital
2,220,000
Total
PHP 2,420,000
PHP 2,420,000
Pro Forma Balance Sheet as of 30 September 2022
Assets
Liabilities and Capital
Cash
Accounts Payable
Accounts Receivable
Inventory
Non-current asset
А. Сарital
Total
PHP 0
PHP 0

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Balance Sheet:

VIEW

Solution:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Blue Book printing is budgeting sales of 25,000 units and already has 5,000 in beginning inventory. How many units must be produced to also meet the 7,000 units required in ending inventory?
Please help!
A company's data regarding its operations follow: 1. Sales budget November $360,000 December $375,000 January $450.000 2. Collection schedule: Month of sale 70% Next month 28% Uncollectible 2% 3. The cost of goods sold is 50% of sales. 4. Other monthly expenses to be paid in cash are $21,000 5. Monthly depreclation is $15,000. 6.60% of the purchase is paid for in the month of purchase, the remainder is paid in the following month. 7. The company declared a special dividend of $10,000 on November 5 to be paid on November 30. Q. Budgeted net income for November would be: ?
Blue Spruce, Inc. provided the following information: March April May Projected merchandise purchases $67,000 $77,500 $81,500 • Blue Spruce pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. • General operating expenses are budgeted to be $24,000 per month of which depreciation is $2,300 of this amount. Blue Spruce pays operating expenses in the month incurred. Calculate Blue Spruce’s budgeted cash disbursements for May. Budgeted cash disbursements $enter the budgeted cash disbursements in dollars
The cost of December merchandise purchases would be: P255,000 P139,500 P235,500 P240,000
Kent Company has a sales budget for next month of $1,000,000. Cost of goods sold is expected to be 25 percent of sales. All goods are paid for in the month following purchase. The beginning inventory of merchandise is $50,000, and an ending inventory of $64,000 is desired. Beginning accounts payable is $160,000. For Kent Company, the ending accounts payable should be: Select one: O A. $341,000 B. $414,000 C. $264,000 D. $356,000
(b) Spana Company has the following data: [Syarikat Spana mempunyai data berikut:) Table 4: Total Monthly Purchasing Budget [Jadual 4: Jumlah Belanjawan Pembelian Bulanan] Month January February March Budgeted Purchases 220,000 185,000 240,000 155,000 180,000 April May Purchases are paid as follows: [Pembelian dibayar seperti berikut:] • 10% in the month of purchase [10% dalam bulan di beli] • 60% one month after purchase [60% sebulan selepas beli] 30% two months after purchase [30% dua bulan selepas beli] Required: (Dikehendaki) (i) Develop a schedule of cash disbursements for purchases for March, April and May. [Bangunkan jadual pembayaran tunai untuk pembelian bagi Mac, April dan Mei.]
Rawlings Company prepared the following budget information for the coming year: Product A Product B Product C Sales $5,714 $1,000,000 $177,777 Variable exp. 25.714 800.000 97.777 Contrib. mar. S60.000 $200.000 S80.000 Fixed exp. Net income The budget assumes the sale of 20,000 units of A, 100,000 units of B, and 80,000 units of C. Fixed Expenses for the company are $255,000. What is the company's combined contribution margin ratio rounded to two decimal places. O 0.21 O 0.27 0.23 0.36
Spana Company has the following data: Table 4: Total Monthly Purchasing Budget Month Budgeted Purchases January 220,000 February 185,000 March 240,000 April 155,000 May 180,000 Purchases are paid as follows: ∙ 10% in the month of purchase ∙ 60% one month after purchase ∙ 30% two months after purchase Required: (i) Develop a schedule of cash disbursements for purchases for March, April and May.