Please Help with Picture this assignment, Unsure which values go where and please adhere to excel rules

Picture This, Inc. Additional information: Ending finished goods inventory should be 40 percent of the next month's sales Ending direct materials inventory should be 30 percent of the next month's production