Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1)Loweland Corp has the following sales data forecast for the coming year Q1 Budgeted sales in units 4,160.00 Q2 Budgeted sales in units 5,200.00 Q3
1)Loweland Corp has the following sales data forecast for the coming year
Q1 Budgeted sales in units 4,160.00
Q2 Budgeted sales in units 5,200.00
Q3 Budgeted sales in units 6,240.00
Q4 Budgeted sales in units 5,720.00
Selling price/ per unit $10.40
Sales collection in current quarter 65%
Sales collection in next quarter 30%
Uncollectible 5%
Last year outstanding A/R $41,860.00
Last year ending inventory 1040.00
desired ending inventory is 7.80% of next quarter budgeted sales
desired ending inventory for the forth quarter is 1170.00
Please prepare the Sales and Production Budget.
2) Mindful Corp has following data to prepare the materials purchase budget
Q1 Required Production in units 5,304.00
Q2 Required Production in units 4,624.00
Q3 Required Production in units 4,216.00
Q4 Required Production in units 4,964.00
1st Quarter Beg raw materials inventory 2121.60 kg
1st Quarter Beg Accounts Payable $10,077.60
Each unit materials weight 1.36kg
Each kg costs $2.72
Desired Inventory is 13.6% of next quarter purchase
Desired ending inventory for 4th quarter in 2135.20
80% Current quarter purchase paid in current quarter
20% Current quarter purchase paid in next quarter
Please prepare the materials purchase budget.
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