Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions. Find the product ID for the LL Road Frame – Black 60.

Journalize the following transactions that occurred in september 2015 for aquamarines. no explanations are needed. identify each accounts payable and accounts receivable with the vendor or customer name. sep. 3 purchased merchandise inventory on account from shallin wholesalers, $5,000. terms 1/15, n/eom, fob shipping point. 4 paid freight bill of $80 on september 3 purchase. 4 purchased merchandise inventory for cash of $1,700. 6 returned $500 of inventory from september 3 purchase. 8 sold merchandise inventory to hermosa company, $6,000, on account. terms 2/15, n/35. cost of goods, $2,640. 9 purchased merchandise inventory on account from thomas wholesalers, $8,000. terms 2/10, n/30, fob destination. 10 made payment to shallin wholesalers for goods purchased on september 3, less return and discount. 12 received payment from hermosa company, less discount. 13 after negotiations, received a $200 allowance from thomas wholesalers. 15 sold merchandise inventory to jordan company, $2,500, on account. terms 1/10, n/eom. cost of goods, $1,050. 22 made payment, less allowance, to thomas wholesalers for goods purchased on september 9. 23 jordan company returned $400 of the merchandise sold on september 15. cost of goods, $160. 25 sold merchandise inventory to smithsons for $1,100 on account that cost $400. terms of 2/10, n/30 were offered, fob shipping point. as a courtesy to smithsons, $75 of freight was added to the invoice for which cash was paid by aquamarines. 26 after negotiations, granted a $100 allowance to smithsons for merchandise purchased on september 25. 29 received payment from smithsons, less allowance and discount. 30 received payment from jordan company, less return.

conquest, inc. produces a special kind of light-weight, recreational vehicle that has a unique design. it allows the company to follow a cost-plus pricing strategy. it has $9,000,000 of average assets, and the desired profit is a 10% return on assets. assume all products produced are sold. additional data are as follows: sales volume 1000 units per year; variable costs $1000 per unit; fixed costs $4,000,000 per year; using the cost-plus pricing approach, what should be the sales price per unit?

The owner of firewood to go is considering buying a hydraulic wood splitter which sells for $50,000. he figures it will cost an additional $100 per cord to purchase and split wood with this machine, while he can sell each cord of split wood for $125. if, for this machine, design capacity is 50 cords per day, effective capacity is 40 cords per day, and actual output is expected to be 32 cords per day, what would be its efficiency?