Arizona State University Managerial Accounting Case Study
Description
Please review part of my Sales and Production budget answers if correct and I would need an explanation/answers to the cash budget and the 3 remaining questions – I will attach the case study for your viewing – I thank you – Questions
1) a-Prepare a sales, b- production and c- cash budget
2) Prepare the projected Income and Balance Sheet Statements
Below are my answers to Question I – a and b Sales and Production budget only – Please view –
I would still require 1- C to be answered and Question # 2
—————————–
My answers to 1-a and 1-b
Please prepare sales budget for YEAR 1 -2 -3
Answer: SALES BUDGET
YEAR 1 |
Year 2 |
Year 3 |
||||
Sep 13 to Feb 14 |
Feb 15 to Sept 12 |
Sep 13 to Feb 14 |
Feb 15 to Sept 12 |
Sept 13 to Feb 14 |
Feb 15 to Sep 12 |
|
PARTICULARS |
First 6 Months |
Last 6 Months |
First 6 Months |
Last 6 Months |
First 6 Months |
Last 6 Months |
Estimated Unit Produced |
450 |
510 |
480 |
540 |
540 |
540 |
Projected Unit Sales |
450 |
510 |
480 |
540 |
540 |
540 |
X Unit Sales |
$120 |
$120 |
$120 |
$120 |
$120 |
$120 |
Projected Sales Amt |
$54,000 |
$61,200 |
$57,600 |
$64,800 |
$64,800 |
$64,400 |
Based on figures above for YEAR 2: Please prepare a PRODUCTION BUDGET
SEP |
OCT |
NOV |
DEC |
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
YEAR |
|
FORECASTED UNIT SALES |
80 |
80 |
80 |
80 |
80 |
80 |
90 |
90 |
90 |
90 |
90 |
90 |
0 |
ADD: PLANNED ENDING INVENTORY |
40 |
40 |
40 |
40 |
16 |
16 |
16 |
72 |
54 |
54 |
54 |
36 |
|
TOTAL PRODUCTION REQUIRED |
120 |
120 |
120 |
120 |
96 |
96 |
106 |
162 |
144 |
144 |
144 |
126 |
|
LESS: BEGINNING INVENTORY |
0 |
0 |
40 |
40 |
40 |
16 |
16 |
16 |
72 |
54 |
54 |
54 |
|
UNITS TO BE MANUFACTURED |
120 |
120 |
80 |
80 |
56 |
80 |
90 |
146 |
72 |
90 |
90 |
72 |
1,096 |
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."