Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Version 2 Section I The data below pertains to the first quarter of Alpha Company which manufactures toys. Below is the estimated sales ( in
Version
Section I
The data below pertains to the first quarter of Alpha Company which manufactures toys.
Below is the estimated sales in units:
tableJanuaryFebruary March AprilMayJune
a The selling price of the toy is $ per unit.
b All sales are on account.
Based on past experience, sales are collected in the following pattern:
Month of sale
Month following sale
Uncollectible
c Sales for December of last year totaled $
d The company maintains finished goods inventories equal to of the following month's sales.
e Each toy requires kilos of raw materials.
f The company requires that the ending inventory of raw materials be equal to of the following month's production needs.
g The raw material costs $ per kilo.
h of a month's purchases of raw materials is paid for in the month of purchase; the remainder is paid after two months
i The accounts payable on December of last year was $
Required for Part I
Prepare:
a Prepare a sales budget, by month and in total, for the first quarter.
marks
b Prepare a schedule of expected cash collections, by month and in total, for the first quarter.
marks
c Prepare a production budget for each months of the first quarter. marks
d Prepare a direct materials budget, by month and in total, for the first quarter.
marks
e Prepare a schedule of expected cash disbursements, by month and in total, for the first quarter.
marks
Total of Section I marks
End of Section I
Section II
Question One
marks
Beta Inc. is a wholesale distributor of beach umbrellas. Thus, peak sales occur in May of each year as shown in the company's sales budget for the second quarter, given below:
April
May
June
Budgeted Sales All on account $$
$
From past experience, the company has learned that of a month's sales are collected in the month of sale, are collected in the month following sale, and the remaining are collected in the second month following sale. February sales totaled $ and March sales totaled $
Required:
Prepare a schedule of expected cash collections from sales for each month April May, and June
marks
Question Two
Marks
Salam company is planning its cash needs for the fourth quarter.
The following information has been assembled to assist in preparing a cash budget for the quarter:
a The Total cash collections and disbursement for purchases are as follows All amounts are in dollars:
c Land costing $ will be purchased in October.
d Dividends of $ will be declared and paid in November.
e The cash balance on October is $
f The company must maintain a cash balance of at least $ at the end of each month.
g The interest rate on the loans is per year. The company's policy is to repay the loan plus accumulated interest at the end of the quarter.
Required: Use rounding if it is needed
Prepare: A cash budget
mark
Section
marks
Please see grade distribution below.
The Introduction part must include an appropriate definition of budgets and elaborate on the need of organizations to create budgets emphasizing the planning and control perspectives. words, single spaced
tableSection Sales budget,Schedule of expected cash collections,Production budget,Direct materials budget,Schedule of expected cash disbursements,TotalSection Schedule of expected cash collections,Cash budget,TotalSection Cover page,Table of contents,IntroductionFormattingReferencingConclusionTotalGrand Total,
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