Question
In: Accounting
Jaka Sdn Bhd., manufactures and sells concrete blocks for residential and commercial building. Jaka expects the...
Jaka Sdn Bhd., manufactures and sells concrete blocks for residential and commercial building. Jaka expects the following sales unit, price per unit and desired ending inventory for year 2021.
|
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
|
|
Sales unit |
2,000,000 |
6,000,000 |
6,000,000 |
2,000,000 |
|
Price/unit (RM) |
0.70 |
0.70 |
0.80 |
0.80 |
|
Ending Inventory |
500,000 |
500,000 |
100,000 |
100,000 |
Inventories for both 1st January 2021 and 1st January 2022 are expected to be 100,000 blocks.
The raw materials and direct labour required for each concrete block are as follows:
|
Units |
Cost |
|
|
Raw materials |
26kg |
RM0.01/kg |
|
Direct labour |
0.015 hour |
RM14/hour |
Jaka’s policy is to have 5 million kg of raw materials in ending inventory for the third and fourth quarters and 8 million kg of the materials in ending inventory for the first and second quarters.
Required:
Prepare the following budgets for the year 2021: -
- Sales budget. Show total sales by quarter and in total for the year.
- Production budget. Show total production unit by quarter and in total for the year.
- Direct material usage and purchase budget.
- Direct labour budget.
Solutions
Expert Solution
| Sr. No. | Sales Budget | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year 2021 | Remarks |
| 1 | Sales units | 2,000,000 | 6,000,000 | 6,000,000 | 2,000,000 | 16,000,000 | |
| 2 | Price/unit | 0.70 | 0.70 | 0.80 | 0.80 | ||
| 3 | Sales value | 1,400,000 | 4,200,000 | 4,800,000 | 1,600,000 | 12,000,000 | 1 X 2 |
| Sr. No. | Production budget | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year 2021 | Remarks |
| 1 | Opening Inventory | 100,000 | 500,000 | 500,000 | 100,000 | 100,000 | |
| 2 | Add: Sales units | 2,000,000 | 6,000,000 | 6,000,000 | 2,000,000 | 16,000,000 | |
| 3 | Less: Closing inventory | -500,000 | -500,000 | -100,000 | -100,000 | -100,000 | |
| 4 | Production units | 1,600,000 | 6,000,000 | 6,400,000 | 2,000,000 | 16,000,000 | 1 + 2 - 3 |
| Sr. No. | Material usage and purchase budget | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year 2021 | Remarks |
| 1 | Production units | 1,600,000 | 6,000,000 | 6,400,000 | 2,000,000 | 16,000,000 | |
| 2 | Raw material usage (26kg per block) | 41,600,000 | 156,000,000 | 166,400,000 | 52,000,000 | 416,000,000 | 2 X 26kg |
| 3 | Add: Opening stock of Raw material | 5,000,000 | 8,000,000 | 8,000,000 | 5,000,000 | 5,000,000 | |
| 4 | Less: Closing stock of Raw material | -8,000,000 | -8,000,000 | -5,000,000 | -5,000,000 | -5,000,000 | |
| 5 | Raw material purchased in units | 38,600,000 | 156,000,000 | 169,400,000 | 52,000,000 | 416,000,000 | 2 + 3 - 4 |
| 6 | Raw material cost (RM 0.01/kg) | 386,000 | 1,560,000 | 1,694,000 | 520,000 | 4,160,000 | 5 X RM0.01 |
| Sr. No. | Labour Budget | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Year 2021 | Remarks |
| 1 | Production units | 38,600,000 | 156,000,000 | 169,400,000 | 52,000,000 | 416,000,000 | |
| 2 | Labour in hrs (0.015 hrs per unit) | 579,000 | 2,340,000 | 2,541,000 | 780,000 | 6,240,000 | 1 X 0.015 hrs |
| 3 | Labour cost (RM14/hr) | 8,106,000 | 32,760,000 | 35,574,000 | 10,920,000 | 87,360,000 | 2 X RM 14 |
ekkarill92 answered 1 year agoRelated Solutions
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential
and commercial building. TBA expects to sell the following in
20x1:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Units 2,000,0000 6,000,000 6,000,000 2,000,000
Unit Selling Price $0.70 $0.70 $0.80 $0.80
Quarter Units Sales Ending Inventory
1 2,000,000 500,000
2 6,000,000 500,000
3 6,000,000 100,000
4 2,000,000 100,000
Inventory on both January 1, 20x1, and January 1, 20x2, is
expected to be 100,000 blocks.
Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential
and commercial building. TBA expects to sell the following in
20x1:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Units 2,000,0000 6,000,000 6,000,000 2,000,000
Unit Selling Price $0.70 $0.70 $0.80 $0.80
Quarter Units Sales Ending Inventory
1 2,000,000 500,000
2 6,000,000 500,000
3 6,000,000 100,000
4 2,000,000 100,000
Inventory on both January 1, 20x1, and January 1, 20x2, is
expected to be 100,000 blocks.
Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential
and commercial building. TBA expects to sell the following in
20x1:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Units 2,000,0000 6,000,000 6,000,000 2,000,000
Unit Selling Price $0.70 $0.70 $0.80 $0.80
Quarter Units Sales Ending Inventory
1 2,000,000 500,000
2 6,000,000 500,000
3 6,000,000 100,000
4 2,000,000 100,000
Inventory on both January 1, 20x1, and January 1, 20x2, is
expected to be 100,000 blocks.
Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential
and commercial building. TBA expects to sell the following in
20x1:
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Units 2,000,0000 6,000,000 6,000,000 2,000,000
Unit Selling Price $0.70 $0.70 $0.80 $0.80
Quarter Units Sales Ending Inventory
1 2,000,000 500,000
2 6,000,000 500,000
3 6,000,000 100,000
4 2,000,000 100,000
Inventory on both January 1, 20x1, and January 1, 20x2, is
expected to be 100,000 blocks.
Each block requires 26 pounds of raw...
Hakim Sdn Bhd manufacturers water filtration system products that are used in both residential and commercial...
Hakim Sdn Bhd manufacturers water filtration system products
that are used in both residential and commercial building. One of
its products named product B is made using two different raw
materials and two types of labour. The company operate a standard
absorption costing system and now preparing its budgets for the
first quarter for the year ending 31 December 2020.
In order to produce one unit of product B, two types of
materials are required namely material X and Y....
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific...
Preston Concrete is a major supplier of concrete to residential
and commercial builders in the Pacific Northwest. The company's
general pricing policy is to set prices at $128 per cubic yard.
Deliveries for 2019 were 380,000 cubic yards, and total costs
were:
Material costs
$25,536,000
Yard operation costs
$5,700,000
Administrative costs
$1,140,000
$4,218,000 of the estimated total yard operation costs were
variable, and all of the administrative costs were fixed. In
addition to the costs above, estimated fixed delivery costs...
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific...
Preston Concrete is a major supplier of concrete to
residential and commercial builders in the Pacific Northwest. The
company's general pricing policy is to set prices at $117 per cubic
yard. Deliveries for 2019 were 400,000 cubic yards, and total costs
were:
Material costs $22,840,000
Yard operation costs $5,600,000
Administrative costs $2,360,000
$1,456,000 of the estimated total yard operation costs were
fixed, and all of the administrative costs were fixed. In addition
to the costs above, estimated fixed delivery costs...
ZACK Sdn Bhd manufactures one standard product, which sells at RM10.00. You are required to: (a)...
ZACK Sdn Bhd manufactures one standard product, which sells at
RM10.00. You are required to:
(a)
prepare from the data below, a break even and profit volume
graph showing the results for the six months ending 30 April 2019
and to determine:
(i)
the fixed cost;
(ii)
the variable cost per unit;
(iii)
the profit-volume ratio;
(iv)
the break-even point;
(v)
the margin of safety;
QUESTION 1
Month
Sales (units)
Profit/(Loss) (RM)
November
30,000
40,000
December
35,000
60,000
January
15,000...
Question 3 Barbie Sdn Bhd (BSB) manufactures and sells a single product which is a barbie...
Question 3
Barbie Sdn Bhd (BSB) manufactures and sells a single product
which is a barbie doll. Following information are provided
below:
RM
Manufacturing costs:
Direct materials cost per unit 55
Direct labor cost per unit 45
Variable overhead cost per unit 36
Fixed overhead cost in total 51,000
Selling expenses:
Variable selling expenses per unit 14
Fixed selling expenses in total 18,000
The selling price for each unit of barbie doll is RM220.00.
Required:
a) Differentiate between variable cost...
Below is the information on the operation of Spice Sdn. Bhd. which manufactures a health product...
Below is the information on the operation of Spice Sdn.
Bhd. which manufactures a health product under the brand name
SS:
Standard Cost
Card
RM
Direct
material
0.8kg at RM12 per
kg
9.60
Direct labour
3 hours at RM6 per
hour
18.00
Variable overhead 4 hours at RM2.90 per
hour
11.60
39.20
For the month of July 2020, the company has estimated to
manufacture and sell 4,875 units of SS at a standard...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT