Daily Sales vs Labor Dashboard.

Build a daily sales versus labor dashboard for The Copper Kettle, a 60 seat full service restaurant in Asheville, used by the general manager every morning to judge whether yesterday made money before payroll makes it official. Lay out three regions. First, a row of four stat cards: Net Sales for the Last 7 Days near $44,500, Labor Cost Percent for the last 30 days at 31.2 percent shown against a 30 percent target, Sales Per Labor Hour at $56, and Covers for the Last 7 Days near 1,150, each with a small change indicator versus the prior period. Second, two charts side by side: a line chart of daily labor cost percent across the selected range with a flat reference line at the 30 percent target, and a grouped bar chart comparing average net sales and average labor dollars by day of week, Monday through Sunday. Third, the daily log table, newest first and grouped by week, with columns for date, day, net sales, covers, front of house hours, back of house hours, labor dollars, labor percent, and sales per labor hour. Close each week group with a bold weekly summary row totaling sales, covers, and hours and showing the week's blended labor percent, colored green at or under 30 percent, amber up to 33, red above. Put two filters above the table: a department toggle for All, Front of House, and Back of House that filters the hour columns and the labor charts, and a range picker for the last 30, 60, or 90 days that drives every region. Default to All and 90 days. Seed 90 consecutive daily entries ending yesterday. Each entry captures net sales, covers, front of house hours, and back of house hours. Compute labor dollars with blended rates of 16 dollars per front of house hour and 19 dollars per back of house hour; labor percent and sales per labor hour are computed, never entered. Weekends run 7,800 to 9,600 in net sales with 190 to 230 covers; most weekdays run 3,900 to 6,200. Plant two stories a visitor should spot: Tuesdays sag near 3,200 in sales while scheduled hours stay flat, pushing Tuesday labor percent toward 39, plainly a scheduling problem, and the latest four weeks show a patio bump lifting Friday and Saturday sales about 15 percent. Add an Add Daily Entry button opening a dialog for date, net sales, covers, and hours by department. The page must read complete and tell the Tuesday story from seeded data alone, with no clicks required. Use a deep blue accent for primary actions, chart emphasis, and active states on a clean light neutral base, with the crisp feel of a morning numbers briefing.