Question
Webster Company has the following sales budget. January P200,000 February P240,000 March P300,000 April P360,000 Cost of sales is 70% of sales. Sales are collected
Webster Company has the following sales budget.
January P200,000
February P240,000
March P300,000
April P360,000
Cost of sales is 70% of sales. Sales are collected 40% in the month of sale and 60% in the following month. Webster keeps
inventory equal to double the coming month's budgeted sales requirements. It pays for purchases 80% in the month of purchase
and 20% in the month after purchase. Inventory at the beginning of January is P190,000. Webster has monthly fixed costs of
P30,000 including P6,000 depreciations. Fixed costs requiring cash are paid as incurred.
Required:
a. Compute budgeted cash receipts in March.
b. Compute budgeted accounts receivable at the end of March.
c. Compute budgeted inventory at the end of February.
d. Compute budgeted purchases in February.
e. March purchases are P290,000. Compute budgeted cash payments in March to suppliers of goods.
f. Compute budgeted accounts payable for goods at the end of February.
g. Cash at the end of February is P45,000. Cash disbursements are not required for anything other than payments to
suppliers and fixed costs. Compute the budgeted cash balance at the end of March.
Following are Blaisdel Company's balance sheet at December 31, 20X0, and information regarding Blaisdel's policies
and past experiences.
Blaisdel Company
Balance Sheet at December 31,20X0
Assets Equities
Cash P 33,000 Accounts payable P 9,000
Receivables 31,000 Income taxes payable 8,000
Inventory 59,000 Common stocks 180,000
Fixed assets, net 102,000 Retained earnings 28,000
Total P225,000 Total P225,000
Additional information:
A. All sales are on credit and are collected 30% in the month of sale and 70% in the month after sale.
B. Budgeted sales for the first five months of 20X1 are P50,000, P60,000, P70,000, P66,000, and P65,000,
respectively.
C. Inventory in maintained at budgeted sales requirements for the following two months.
D. Purchases are all on credit and are paid 80% in the month of purchase and 20% in the month after purchase.
E. Other variable cost are 20% of sales and are paid in the month incurred.
F. Fixed costs are P6,000 per month, excluding P1,000 of depreciation. Cash fixed costs are paid in the month
incurred.
G. Blaisdel's income tax rate is 25%, with taxes being paid in the month after they are accrued.
H. Cost of goods sold is expected to be 60% of sales.
Required:
1. Projected Income Statement for January to May 30, 20x1.
2. Projected schedule of inventory levels from January to March 20x1 showing the beginning
inventory, purchases, and ending inventory for eachh month.
3. Projected schedule of receivables from January to May 20x1.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started