Mang Eduard operates a buy and sell business. He sells umbrellas in his shop near the city mall. He gets his umbrellas from a local dealer. Each umbrella costs 90.00 pesos each. Expecting rainy season to come, Mang Eduard purchased 4 dozens of umbrellas every week. The supplier then charges 200.00 pesos per dozen for freight. Mang Eduard can sell 12 umbrellas every day. Remember to use the factors to consider in projecting revenues and refer to tables 4, 5 and 6 as your guide. Suppose Mang Eduard purchases and sales is the same every month, fill in the necessary information in table 6. TABLE 4: PROJECTED COST OF GOODS SOLD MONTHLY MERCHANDISE/PRODUCTS COST PER UNIT PROJECTED VOLUME AVERAGE NO. OF ITEMS SOLD (MONTHLY) PROJECTED COSTS OF PURCHASES (MONTHLY) (A) F= (D x 30 DAYS) J=( A x F) TOTAL TABLE 5: FREIGHT-IN PAID MERCHANDISE/PRODUCTS NO. OF ITEMS SOLD (DAILY) PROJECTED VOLUME AVERAGE NO. OF ITEMS PURCHASED (MONTHLY) FREIGHT IN ( 1 MONTH ONLY) (A) F= (D x 30 DAYS) J=(F/12) x 200.00 TOTAL TABLE 6: PROJECTED MONTHLY COSTS (YEAR 1) MONTH JANUARY FEBRUARY MARCH APRIL MAY JUNE COSTS OF GOOD SOLD EXPENSES TOTAL COSTS & EXPENSES MONTH JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER COSTS OF GOOD SOLD EXPENSES TOTAL COSTS & EXPENSES
Mang Eduard operates a buy and sell business. He sells umbrellas in his shop near the city mall. He gets his umbrellas from a local dealer. Each umbrella costs 90.00 pesos each. Expecting rainy season to come, Mang Eduard purchased 4 dozens of umbrellas every week. The supplier then charges 200.00 pesos per dozen for freight. Mang Eduard can sell 12 umbrellas every day. Remember to use the factors to consider in projecting revenues and refer to tables 4, 5 and 6 as your guide. Suppose Mang Eduard purchases and sales is the same every month, fill in the necessary information in table 6.
TABLE 4: PROJECTED COST OF GOODS SOLD MONTHLY
|
MERCHANDISE/PRODUCTS |
COST PER UNIT |
PROJECTED VOLUME AVERAGE NO. OF ITEMS SOLD (MONTHLY) |
PROJECTED COSTS OF PURCHASES (MONTHLY) |
|
(A) |
F= (D x 30 DAYS) |
J=( A x F) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL |
|
|
|
TABLE 5: FREIGHT-IN PAID
|
MERCHANDISE/PRODUCTS |
NO. OF ITEMS SOLD (DAILY) |
PROJECTED VOLUME AVERAGE NO. OF ITEMS PURCHASED (MONTHLY) |
FREIGHT IN ( 1 MONTH ONLY) |
|
(A) |
F= (D x 30 DAYS) |
J=(F/12) x 200.00 |
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL |
|
|
|
TABLE 6: PROJECTED MONTHLY COSTS (YEAR 1)
|
MONTH |
JANUARY |
FEBRUARY |
MARCH |
APRIL |
MAY |
JUNE |
|
COSTS OF GOOD SOLD |
|
|
|
|
|
|
|
EXPENSES
|
|
|
|
|
|
|
|
TOTAL COSTS & EXPENSES |
|
|
|
|
|
|
|
MONTH |
JULY |
AUGUST |
SEPTEMBER |
OCTOBER |
NOVEMBER |
DECEMBER |
|
COSTS OF GOOD SOLD |
|
|
|
|
|
|
|
EXPENSES |
|
|
|
|
|
|
|
TOTAL COSTS & EXPENSES |
|
|
|
|
|
|
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
