S6-6 Accounting math question. Please answer in format shown.

core: 0 of 2 pts HYV Score: 36 67%, 11 of 30 pts 6-6 (similar to) New Tech Cycles started March with 25 bicycles that cost 565 each On March 16, New Tech bought 50 bicycles at 580 each On March 31, Now Tech sold 3 Requirements 1. Prepare New Tech Cycle's perpetual inventory rocord assuming the company uses the weighted-average 2. Journalize the March 16 purchase of marchandise inventory o bicycles for $96each cosing method on account and the March 31 sale of merchandise inventory on account Requirement 1. Propare Now Tech Cycle's perpetual inventony record asuming tho company uses the the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period (Abbreviation used QTY Quanity, lox. New Tech Cycles Cost of Goods Sold Inventory on Hand Cost Tot.Cost QTY Unit Cost Tot. Cost QTY Unit Cost Tot. Cost QTY Mar 1 D