In: Accounting
Purchase = cost of good sold + ending merchandise inventory -
beginning merchandise inventory
Cost of good sold:
Product a =($18×42%)× (420×7)
= $7.56× 2940
= $22,226
Product b = ($28×58%) ×(420×7)
= $16.24× 2940
= $47,746
Total cost of good sold= $22,226+ $47,746
= $69,972
Desired ending inventory = (Daily sales × 6 days) × (selling price
× expected cost)
Product a = (420 × 6) ×( $18 × 42%)
= 2520 × $7.56
= $19,051
Product b = (420 ×6) × ($28 × 58%)
= 2520 × $16.24
= $40,925
Total desired inventory = $19,051 + $40,925
= $ 59,976
Purchase= cost of good sold + ending merchandise inventory -
beginning merchandise inventory
Product a = $22,226 + $19,051-0
=$41,277
Product b = $47,746 + $40,925-0
= $ 88,671
Total budgeted purchase = $41,277 + $88,671
Total budgeted purchase = $1,29,948