Question

In: Accounting

A retailer has the following budgeted sales: May $3 000 000 June $2 500 000 July...

A retailer has the following budgeted sales:

May $3 000 000

June $2 500 000

July $2 200 000

August $2 800 000

The store employees earn fixed monthly salaries totalling $120 000 and 10% commissions of

current monthly sales. Disbursements are made semi- monthly, that is half to be paid a month

after salaries and commissions are earned. Other expenses are: Rent $30 000 paid 1st day of each

month miscellaneous expenses 6% of sales insurance $3 000 per month, related to a one year

policy that way paid on 2nd of January.

Depreciation $19 000 per month.

Required

a) Prepare an operating expenses budget for the months of June, July and August

b) Prepare a disbursement budget on the operating expenses for the same period in a) above.

Solutions

Expert Solution

OPERATING EXPENSES	BUGET
\
JUNE

SELLING EXPENSES
SALARIES		120000
COMMISSION	250000
ADMINISRTIVE EXPENSES
RENT		3000
MISCELANEOUS	150000
INSURANCE	3000
DEPERICIATION	19000

TOTAL		545000

JULY
SELLING EXPENSES
SALARY		120000
COMISSION	220000
ADMINISTRRTIVE EXPENSES
RENT		3000
INSURANCE	3000
MISCELLANEOUS	132000
DEPRICIATION	19000

TOTAL		497000

AUGUST
SELLING EXPENSES
SALARY		120000
COMMISSION	280000
ADMINISTRATIVAE
RENT		3000
MISCELLANEOUS	168000
INSURANCE	3000
DEPRICIATION	19000

TOTAL		593000

DISBURSEMENT BUDGET ON OPERATING EXPENSES

JUNE

SALARY 120000(HALF OF MAY AND JUNE SALARY)

COMMISSION 2750000(HALF OF MAY AND JUNE COMMISSION)

RENT 3000

MISCELLANEOUS 150000

TOTAL 548000

JULY

SALARY 120000

COMMISSION 360000

RENT 3000

MISCELLENOUS 132000

TOTAL 615000

AUGUST

SALARY 120000

COMMISSION 250000

RENT 3000

MISCELLENEOUS 168000

TOTAL 541000

(INSURANCE IS PAID IN THE MONTH OF JANUVARY SO IT SHOULD NOT BE ADDED IN DISBURMENT)

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...

Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 3,700 units Past experience has shown that the ending finished goods inventory for each month should be equal to 25% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...

Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...

Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 7,300 units Past experience has shown that the ending finished goods inventory for each month should be equal to 20% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...

2. Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000...

2. Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000 Cash Sales 14,000 25,000 32,000 Total Sales $99,000 $105,000 $104,000 Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory...

Kuzma Foods, Inc. has budgeted sales for June and July at $670,000.00 and $720,000.00, respectively. Sales...

Kuzma Foods, Inc. has budgeted sales for June and July at $670,000.00 and $720,000.00, respectively. Sales are 80% credit, of which 60% is collected in the month of sale and 40% is collected in the following month. What is the budgeted Accounts Receivable balance on July 31? A. $230,400.00 B. $288,000.00 C. $214,400.00 D. $576,000.00 2) Camellia, a merchandising company, has provided the following extracts from their budget for the first quarter of the forthcoming year: Jan Feb March Sales...

Cruises, Inc. has budgeted sales revenues as follows: June July August September Credit sales ($)...

Cruises, Inc. has budgeted sales revenues as follows: June July August September Credit sales ($) 135,000 125,000 $ 90,000 120,000 Cash sales ($) 90,000 255,000 195,000 175,000 Total sales ($) 225,000 380,000 285,000 295,000 Purchases ($) 300,000 240,000 205,000 185,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and 20% will be collected in the following month and the remaining 20% after two months. Purchases of inventory are all...

M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000...

M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000 $45,000 $55,000 • Cost of goods sold is 50% of sales. Accounts payable is used only for inventory acquisitions. • M&H purchases and pays for merchandise 50% in the month of acquisition and 50% in the following month. • Selling and administrative expenses are budgeted at $30,000 for May and are expected to increase 2% per month. They are paid during the month of...

The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...

The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% 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...

: E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for...

: E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July, and $160,000 for August. To prepare a cash budget, the company must determine the budgeted cash collections from sales. Generally the trend has been 55 percent collected in the month of sale, 25 percent collected in the month following sale, 18 percent collected in the second month following sale, and 2 percent uncollectible. Also, E Company grants a 2 percent cash discount to...

Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales...

Question 4: Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit Sales $135,000 $145,000 $90,000 Cash Sales $90,000 $255,000 $195,000 Total Sales $225,000 $400,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase....

Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit sales $135,000 $145,000...

Rodie Company has budgeted sales revenues as follows: Particulars June July August Credit sales $135,000 $145,000 $ 90,000 Cash sales 90,000 255,000 195,000 Total sales $225,000 $400,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted...

Subjects