my 2 questions are in .jpeg file below need complete answer on word file with step by step answer thanks .
æ—¥
david lee
Sep3, 2020 PROIS006-AIM in-class notes – Excel
–
Tell me what you want to do
File
Home
Insert Page Layout
Formulas
Data
Review
View
A Share
cut
Calibri
– 11 AA
General
Bad
Good
Neutral
Calculation
–
47
• REC
Help QuickBooks
29 Wrap Text
== Merge & Center
Alignment
Normal
Conditional Format as Check Cell
Formatting Table
BIU
A
들들로
00
S – %
Explanatory. Hyperlink
Input
Linked cell
Insert Delete Format
AutoSum
Fill-
Sort & Find
Clear
Filter – Select
Editing
mat Painter
Clipboard
Font
Number
Styles
Cells
119
B
c
D
E
F
G
H
J
K
L
M
N
o
P
R
3760
4700
5640
5170
9,4
65%
30%
5%
37835
01 Required Production in units
a2 Required Production in units
Q3 Required Production in units
Q4 Required Production in units
1st Quarter Beg raw materials inventory in kg
1st Quarter Beg Accounts Payable
Each unit materials weight in kg
Each kg costs
Desired Inventory is % of next quarter purchase
Desired ending inventory for 4th quarter in kg
Current quarter purchase paid in current quarter
Current quarter purchase paid in next quarter
2964
2584
2356
2774
1185.6
5631.6
0.76
1.52
7.60
1193.2
75%
25%
940
7.05%
1057.5
Please prepare the material purchase budget
O
Assignment 6
A
1 Q1 Budgeted sales in units
2 02 Budgeted sales in units
303 Budgeted sales in units
4 04 Budgeted sales in units
5 Selling price/ per unit
6 Sales receipt collection in current quarter
7 Sales receipt collection in next quarter
8 Uncollectible
9 Last year outstanding A/R
10
11 Last year ending product inventory
12 desired ending product inventory is 7.05% of next quarter budgeted sales volume
13 desired ending product inventory for the forth quarter is
14
15 Please prepare the sales budget and production budget
16
17
18 Assignments
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
1
Assignment2
A2
NPV-1
NPV-2
A4 Cost Concept quick review
Cost Concept quick review 2
Sheet
Sheets
A5
A6
Ready
Purchase answer to see full
attachment
