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...
Kuzma​ Foods, Inc. has budgeted sales for June and July at $690,000 and $745,000​, respectively. Sales...
Kuzma​ Foods, Inc. has budgeted sales for June and July at $690,000 and $745,000​, respectively. Sales are 80​% ​credit, of which 70​% is collected in the month of sale and 30​% is collected in the following month. What is the budgeted Accounts Receivable balance on July​ 31? A. 596,000 B. 223,500 C. 165,600 D. 178,800
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....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT