1
answer
0
watching
247
views

Thornton Company is a retail company that specializes in sellingoutdoor camping equipment. The company is considering opening a newstore on October 1, 2019. The company president formed a planningcommittee to prepare a master budget for the first three months ofoperation. As budget coordinator, you have been assigned thefollowing tasks:

Required

October sales are estimated to be $400,000, of which 40 percentwill be cash and 60 percent will be credit. The company expectssales to increase at the rate of 30 percent per month. Prepare asales budget.

The company expects to collect 100 percent of the accountsreceivable generated by credit sales in the month following thesale. Prepare a schedule of cash receipts.

The cost of goods sold is 70 percent of sales. The companydesires to maintain a minimum ending inventory equal to 20 percentof the next month’s cost of goods sold. However, ending inventoryof December is expected to be $13,500. Assume that all purchasesare made on account. Prepare an inventory purchases budget.

The company pays 70 percent of accounts payable in the month ofpurchase and the remaining 30 percent in the following month.Prepare a cash payments budget for inventory purchases.

Budgeted selling and administrative expenses per monthfollow:

Salary expense (fixed) $ 19,500
Sales commissions 4 % of Sales
Supplies expense 2 % of Sales
Utilities (fixed) $ 2,900
Depreciation on store fixtures(fixed)* $ 5,500
Rent (fixed) $ 6,300
Miscellaneous (fixed) $ 2,700

*The capital expenditures budget indicates that Thornton willspend $167,000 on October 1 for store fixtures, which are expectedto have a $35,000 salvage value and a two-year (24-month) usefullife.

Use this information to prepare a selling and administrativeexpenses budget.

Utilities and sales commissions are paid the month after theyare incurred; all other expenses are paid in the month in whichthey are incurred. Prepare a cash payments budget for selling andadministrative expenses.

Thornton borrows funds, in increments of $1,000, and repays themon the last day of the month. Repayments may be made in any amountavailable. The company also pays its vendors on the last day of themonth. It pays interest of 2 percent per month in cash on the lastday of the month. To be prudent, the company desires to maintain a$27,000 cash cushion. Prepare a cash budget.

Thornton Company is a retail company that specializes in sellingoutdoor camping equipment. The company is considering opening a newstore on October 1, 2019. The company president formed a planningcommittee to prepare a master budget for the first three months ofoperation. As budget coordinator, you have been assigned thefollowing tasks:

Prepare a pro forma income statement for the quarter.

Prepare a pro forma balance sheet at the end of the quarter.

Prepare a pro forma statement of cash flows for the quarter.

For unlimited access to Homework Help, a Homework+ subscription is required.

Trinidad Tremblay
Trinidad TremblayLv2
28 Sep 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in

Related questions

Weekly leaderboard

Start filling in the gaps now
Log in