1
answer
0
watching
274
views

Has Company is a retail company that specializes i...

Bookmark

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

Required

a&b.October sales are estimated be 250,00 of which 40percent will be cash and 60 percent will be credit.The companyexpects sales to increase at the rate of 8 percent per month .Thecompany expects to collect 100 percent of the accounts receivablegenerated by credit sales in the month following the sale .Preparea sales budget and a schedule of cash receipts.

October November December

Sales Budget ____________ ______________ _____________

Cash Sales ______________ __________________ _________________

Sales on Account ___________ _________________________________

Total budgeted Sales _____________ ___________________________________

schedule on cash Receipts _____________ _____________________________________

Current Cash Sales ____________ ______________________________________

Pus collections from A/R ______________ ________________________________________

Total Collections _______________ _______________________________________

c&d.The cost of goods sold is 60 percent of sales.thecompany desires to maintain a minimum ending inventory equal to 10percent of the next month's cost of goods sold.However,endinginventory of December is expected to be $12,000.the company pays 70percent of accounts payable in the month of purchase and theremaining 30 percent in the following month assume that allpurchases are made on account .Prepare an inventory purchasesbudget and a cash payments budget for inventory purchases(Roundyour answers to the nearest whole dollar).

October November December

Inventory purchase budget ______________________________________ ________________

Purchases ___________________ _________________________________________

Plus or Less desired ending inventory ________________________________ ____________________

Inventory need ____________ _________________________________________

_______________________________________________________________________________________________________

Required purchases on account ___________________________________ ______________________

Schedule of Cash Payments Budget for inventoryPurchases_____________ ______________ __________________

Payments of current month's accounts payables ______________________________ _________________

Payment for prior month's accounts payable ____________________________ _________________

Total budgeted payments for inventory ___________________________ _________________

e&f.Budgeted selling and administrative expenses per monthfollow

Salary expense (fixed) $18,000

sales commissions 5% of sales

Supplies Expense 2 percent of sales

utilities(fixed) $1,400

Depreciation on store fixtures(fixed) $4,000

Rent(fixed) $4,800

Miscellaneous( fixed ) 1,200

The capital expenditures budget indicates that Haas will spend$164000 on October 1 for store fixtures ,which are expected to havea $20,000 salvage value and a three -year 936) month usefullife.

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 selling and administrative expensesbudget and a cash payments budget for selling and administrativeexpenses .(Round your answers to the nearest whole dollaramount)

October November December

Selling and administrative Expense budget ____________________________ _________________

Salary Expense ______________ _________________________________

Sales Commissions ____________ ____________________________________

Supplies expenses _________ ________________________________

Utilities _____________ __________ ________________

Depreciation on store fixtures

Rent

Miscellaneous

Total S&A EXPENSES

Salary expense

Sales commissions

Supplies expense

utilities

Depreciation on store fixtures

Rent

Miscellaneous

total payments for S&A expenses.

g-HaaS borrows funds in increments of $1,000,and repays them onthe 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 1 percent per month in cash on the lastday of the month.To be prudent,the company desires to maintain a12,000 cash cushion .prepare a cash budget(Any repayments/shortagewhich should be indicated with a minus sign .Round your answers tonearest whole dollar amount)

Cash Budget

October November December

______________________________________________________________________________

Cash available

________________________________________________________________________________________

Lees:Payments

_______________________________________________________________________________________

_________________________________________________________________________________________

_____________________________________________________________________________________________

_______________________________________________________________________________________________

________________________________________________________________________________________________

Total budgeted payments

Payments minus receipts

____________________________________________________________________________________________

Financing activity

_____________________________________________________________________________________________

_______________________________________________________________________________________________

h.Prepare a pro-forma income statement for the quarter (Roundyour answers to nearest whole dollar amount)

Haas Company

Pro forma income statement

For the Quarter ended December 31,,2015

i.

Prepare a pro forma balance sheet at the end of thequarter9Amounts to be deducted should be indicated by a minussign

Haas Company

Pro Forma Balance Street

As of December 31,2015

Assets _____________ _______________

_________

_________

____________

_____________

____________

_______________

Total assets ________________

Liabilities

___________

____________

_____________

_____________

Stockholders 'equity

___________________

_______________________

Total liabilities and stockholders equity_____________________

j.Prepare a pro forma statement of cash flows for thequarter(Amounts to be deducted should be indicated by a minussign.Round your answers to nearest whole dollar amount.)

Haas Company

Pro Forma Statement of Cash Flows

Cash flows from operating activities ____________________________________________

_________________________________________________________________________________

_______________________________________________________________________________

_______________________________________________________________________________

_______________________________________________________________________________

________________________________________________________________________________

Net Cash flows from operating activities ___________________

Cash flows from investing activities_______________________________________________

_______________________________________ ________________________________________

Cash flow from financing activities _______________________________________

__________________________________ _______________________________________

__________________________________ _______________________________________

__________________________________ _________________________________________

_________________________________ _________________________________________

_______________________________ ___________________________________________

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

Reid Wolff
Reid WolffLv2
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